Led by community member Vishal Gupta (
Vishal, a big data engineer and BigQuery developer, shares some specific optimizations in their BigQuery setup, including pre-aggregated tables, auditing queries, table clusters, and user training on these new methods. View the full video below.
Other BigQuery optimizations from Google Cloud:
- Clustered tables
- Restricting number of billed bytes
- Pricing tables to optimize cloud storage
- https://cloud.google.com/bigquery/docs/information-schema-jobs#schema
Links shared by Vishal and the community: