How does query processing work in BigQuery?

Опубликовано 29 июля 2021, 16:00

Read the blog → goo.gle/3iWWSDJ
Read the docs → goo.gle/2VjJTn7

Ever wonder how BigQuery processes your data and executes queries? In this episode of BigQuery Spotlight, we’ll examine the life of a query and show you how to leverage the query plan to troubleshoot and optimize your SQL. We’ll also cover the architecture of BigQuery and what actually happens when you submit a query for it to run.

Timestamps:
0:00 - Intro
0:31 - Architecture
1:08 - Memory Shuffle
1:33 - Life of a query
3:37 - Execution of a simple query
4:30 - Accessing execution details
5:48 - Using the query plan
6:35 - Summary

Watch more episodes of BigQuery Spotlight → goo.gle/BQSpotlight
Subscribe to Google Cloud Tech → goo.gle/GoogleCloudTech


#BigQuerySpotlight

product: Cloud - Data Analytics - BigQuery; re_ty: Publish;