Understanding jobs & the reservation model in BigQuery
Read the blog → https://goo.gle/3hX4eYx
Jobs docs → https://goo.gle/3hrU7uw
Reservation model docs → https://goo.gle/3wuqg93
What are jobs in BigQuery and how does the reservation model work? In this episode of BigQuery Spotlight, we’ll review jobs, reservations, and best practices for managing workload in BigQuery. We’ll also walk you through the difference between BI Engine reservations and standard reservations, so you can decide what will work best for you.
Timestamps:
0:00 - Intro
00:25 - What is a job?
01:32 - What is a slot?
02:34 - BigQuery Pricing Models
03:03 - What is a reservation?
03:32 - What is an assignment?
05:27 - Jobs & Reservations in the Resource Hierarchy
06:33 - Demo from the console
07:56 - BigQuery Reservation vs. BI Engine Reservation
08:29 - Conclusion
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to Google Cloud Tech → http://goo.gle/GoogleCloudTech
#BigQuerySpotlight
product: Cloud - Data Analytics - BigQuery; fullname: Leigha Jarett;
Видео Understanding jobs & the reservation model in BigQuery канала Google Cloud Tech
Jobs docs → https://goo.gle/3hrU7uw
Reservation model docs → https://goo.gle/3wuqg93
What are jobs in BigQuery and how does the reservation model work? In this episode of BigQuery Spotlight, we’ll review jobs, reservations, and best practices for managing workload in BigQuery. We’ll also walk you through the difference between BI Engine reservations and standard reservations, so you can decide what will work best for you.
Timestamps:
0:00 - Intro
00:25 - What is a job?
01:32 - What is a slot?
02:34 - BigQuery Pricing Models
03:03 - What is a reservation?
03:32 - What is an assignment?
05:27 - Jobs & Reservations in the Resource Hierarchy
06:33 - Demo from the console
07:56 - BigQuery Reservation vs. BI Engine Reservation
08:29 - Conclusion
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to Google Cloud Tech → http://goo.gle/GoogleCloudTech
#BigQuerySpotlight
product: Cloud - Data Analytics - BigQuery; fullname: Leigha Jarett;
Видео Understanding jobs & the reservation model in BigQuery канала Google Cloud Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to structure your BigQuery resourcesStrategies for optimizing your BigQuery queriesCI/CD on Google CloudUnderstanding BigQuery data governanceBest Practices for Cloud MonitoringHow does query processing work in BigQuery?BigQuery Pricing - How It Works and Best PracticesWhat are user-defined functions?Can Cloud Run handle these 9 workloads?Logistics Regression and Feature Engineering using SQL - BigQuery MLHow does BigQuery store data?Google BigQuery Tutorial for beginners | Load Dataset and Run SQL queries for Data AnalysisA tour of BigQuery tablesMonitoring in BigQueryBest practices from experts to maximize BigQuery performance (featuring Twitter)Always Fast and Fresh Dashboards: Inside BigQuery BI EngineHow to monetize BigQuery datasets using ApigeeBigQuery Flat-Rate Billing: Getting Started with Reservations