BigQuery Introduces New Ways to Access Insights and Recommendations

Google Cloud has announced updates to BigQuery, enhancing how users can view and manage insights and recommendations for their BigQuery resources.

Key Updates

1. New Access Points:

   • Recommendations page in the Google Cloud console
   • INFORMATION_SCHEMA views: INSIGHTS, RECOMMENDATIONS, and RECOMMENDATIONS_BY_ORGANIZATION

2. Integration with Active Assist:

   • Provides recommendations to optimize BigQuery resource usage
   • Uses machine learning and heuristics for recommendation generation

3. Available Recommenders:

   • Partitioning and clustering recommender
   • Materialized view recommender
   • IAM recommender

4. Viewing Options:

   • BigQuery Recommendation Hub
   • Recommendation notifications in BigQuery Studio
   • Active Assist Recommendation Hub for cross-service recommendations

How to Access

Users can view recommendations by:

1. Going to the BigQuery page in the Google Cloud console
2. Clicking "Recommendations" in the navigation menu
3. Selecting specific recommendations for more details

Alternatively, users can access recommendations via the lightbulb notification in BigQuery Studio.

These new features are currently in preview, offering BigQuery users more tools to optimize their resource usage and improve performance.