Strategies for optimizing your BigQuery queries
Read the blog → https://goo.gle/3lexNXs
Previous video → https://goo.gle/3y8kFqx
Did you know that optimizing SQL queries can be cost efficient? In this episode of BigQuery Spotlight, we speak to some strategies for optimizing your BigQuery queries. We’ll walk through what happens behind the scenes for more complex queries, and show you specific tactics you can use to optimize your SQL. Watch to learn some great techniques on how to make your queries more performant!
Timestamps:
0:00 - Intro
0:55 - Necessary columns only
1:26 - Prune data with partitions and clusters
1:54 - Aggregations in BigQuery
2:52 - Late aggregation
3:19 - Nest repeated data
4:00 - Shuffle Joins in BigQuery
4:27 - Broadcast Joins in BigQuery
4:55 - JOIN order
5:03 - Filter before joins
5:25 - Cluster on join keys
5:48 - WHERE clause order matters
6:03 - ORDER BY with LIMIT
6:35 - Wrap up
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech
#BigQuerySpotlight
product: Cloud - Data Analytics - BigQuery; fullname: Leigha Jarett;
Видео Strategies for optimizing your BigQuery queries канала Google Cloud Tech
Previous video → https://goo.gle/3y8kFqx
Did you know that optimizing SQL queries can be cost efficient? In this episode of BigQuery Spotlight, we speak to some strategies for optimizing your BigQuery queries. We’ll walk through what happens behind the scenes for more complex queries, and show you specific tactics you can use to optimize your SQL. Watch to learn some great techniques on how to make your queries more performant!
Timestamps:
0:00 - Intro
0:55 - Necessary columns only
1:26 - Prune data with partitions and clusters
1:54 - Aggregations in BigQuery
2:52 - Late aggregation
3:19 - Nest repeated data
4:00 - Shuffle Joins in BigQuery
4:27 - Broadcast Joins in BigQuery
4:55 - JOIN order
5:03 - Filter before joins
5:25 - Cluster on join keys
5:48 - WHERE clause order matters
6:03 - ORDER BY with LIMIT
6:35 - Wrap up
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech
#BigQuerySpotlight
product: Cloud - Data Analytics - BigQuery; fullname: Leigha Jarett;
Видео Strategies for optimizing your BigQuery queries канала Google Cloud Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How does BigQuery store data?Learn how to write SQL Queries(Practice Complex SQL Queries)Partitioning and Clustering with BigQueryWhat is BigQuery?Understanding BigQuery data governanceUnderstanding jobs & the reservation model in BigQueryWhat is Dataflow?How To Get a Data Analyst Job (with No Experience)How does query processing work in BigQuery?Data Warehousing With BigQuery: Best Practices (Cloud Next '19)BigQuery Pricing - How It Works and Best PracticesHow to structure your BigQuery resourcesQuerying external data with BigQueryAsking questions, running queriesBest practices from experts to maximize BigQuery performance (featuring Twitter)Strategies for migrating to the CloudBigQuery Nested and Repeated Fields: Dig Deeper into Data (Cloud Next '18)Build ETL Pipelines using Cloud Dataflow