Google launched Recommendations Page for BigQuery

Get better Insights and Recommendations to tune Performance

Photo by Took A Snap on Unsplash

Google let you now view your BigQuery insights and recommendations using the Recommendations page in the Google Cloud console.

Google offers you different recommenders which can lead to better performance but also saving costs. BigQuery offers the following three recommenders[1]:

• Partitioning and clustering recommender, which analyzes your query behavior to find opportunities for partitioning and clustering to optimize your BigQuery tables.
• Materialized view recommender, which finds opportunities to use materialized views to optimize your workflows.
• IAM recommender, which analyzes permissions on your BigQuery datasets and suggests Identity and Access Management (IAM) role updates for principals that have excess permissions.

You will find the recommender page within the BigQuery SQL tab on the top right corner:

From there you also get to the Recommendations Page where you get deeper insights:

Recommendations — Screenshot by Author