Read the blog → https://goo.gle/3iWWSDJ
Read the docs → https://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 → https://goo.gle/BQSpotlight
Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech
#BigQuerySpotlight
product: Cloud - Data Analytics - BigQuery; re_ty: Publish;
