How does query processing work in BigQuery?
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;
Видео How does query processing work in BigQuery? канала Google Cloud Tech
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;
Видео How does query processing work in BigQuery? канала Google Cloud Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Strategies for optimizing your BigQuery queriesUnderstanding BigQuery data governanceBest practices from experts to maximize BigQuery performance (featuring Twitter)Partitioning and Clustering with BigQueryHow many certs do I need to get a cloud job?How Cloud Spanner delivers strong consistency at scaleBigQuery ML: Machine Learning with Standard SQLWhat is BigQuery?How does BigQuery store data?Understanding the BigQuery API landscape7 Top Tips for Better Business Dashboard Design Data Visualization | BI For BeginnersDay in the Life of a Goldman Sachs Investment Banking Intern NYCQuerying external data with BigQueryGoogle BigQuery TutorialMonitoring in BigQuery5 Ways to Improve Your SQL QueriesHow to choose the right database for application scalabilityCommon Sense Test That 90% of People Fail