Led by community member Vishal Gupta ( @VishalG ) and joined by members of his team, this C2C Talks session covers how they achieved 50% cost reduction and limited the billed bytes per user role for BigQuery analysis.
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:
