Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BigQuery Studio Partition and Clustering recommendations not working

I checked my table, it is pretty big but there are no recommendations, is it possible for me to know why the recommendations are not appearing specifically instead of generic ones like the ones below which are from the public documentation? Thank you.

 

Issue: No recommendations appear for a specific table.

Partition and cluster recommendations might not appear under the following circumstances:

  • The table is less than 10GB.
  • The table has a high write cost from data manipulation language (DML) operations.
  • The table was not read in the past 30 days.
  • The estimated monthly savings is too insignificant (less than 1 slot hour of savings).
  • The table is already clustered.
0 0 79
0 REPLIES 0