Querying external data with BigQuery
Temporary tables for external data sources → https://goo.gle/31O7a1g
Connect to Cloud SQL from BigQuery → https://goo.gle/35D0d45
Technical documentation for external data sources → https://goo.gle/37LicrD
Querying data residing in BigQuery is easy, but what about querying data from outside BigQuery? In this episode of BigQuery Spotlight, we show you how to set up an external data source in BigQuery, allowing you to query data from Cloud Storage, Cloud SQL, Google Drive, and more. Watch to learn how you can utilize BigQuery with other datasets!
Flight performance data → gs://cloud-training/CPB200/BQ/lab4/domestic_2014_flights_*.json
BigQuery Omni blog post → https://goo.gle/3jDye9k
Timestamps:
0:00 - Intro
0:25 - Which external data sources are accessible
0:47 - Considerations with external data sources
1:32 - Use cases for external data sources
2:26 - How to set up an external data source
4:55 - More information and next steps
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to the GCP Channel → https://goo.gle/GCP
#BigQuerySpotlight
Product: BigQuery; fullname: Alicia Williams;
Видео Querying external data with BigQuery канала Google Cloud Tech
Connect to Cloud SQL from BigQuery → https://goo.gle/35D0d45
Technical documentation for external data sources → https://goo.gle/37LicrD
Querying data residing in BigQuery is easy, but what about querying data from outside BigQuery? In this episode of BigQuery Spotlight, we show you how to set up an external data source in BigQuery, allowing you to query data from Cloud Storage, Cloud SQL, Google Drive, and more. Watch to learn how you can utilize BigQuery with other datasets!
Flight performance data → gs://cloud-training/CPB200/BQ/lab4/domestic_2014_flights_*.json
BigQuery Omni blog post → https://goo.gle/3jDye9k
Timestamps:
0:00 - Intro
0:25 - Which external data sources are accessible
0:47 - Considerations with external data sources
1:32 - Use cases for external data sources
2:26 - How to set up an external data source
4:55 - More information and next steps
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to the GCP Channel → https://goo.gle/GCP
#BigQuerySpotlight
Product: BigQuery; fullname: Alicia Williams;
Видео Querying external data with BigQuery канала Google Cloud Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Build your own LLM on Google CloudWhat have Cloud Next 2024 attendees learned at Cloud Next?Developing on PostgreSQL for Cloud SpannerWorkload-optimized and AI-powered infrastructure in under 9 minutesWhat's next for Google Cloud databases in under 10 minutesWhat do Google Cloud Next attendees think of when they hear "Gen AI"?What's next for security professionals in under 4 minutesBuilding a foundation for migration (Part 2)Unlocking AI with a platform strategy in 10 minutesWhat’s next with generative AI at Google Cloud in under 9 minutesHow MLB analyzes data with Google CloudBuild a pet tracking camera appStarting your career in cloud from ITIntroduction to Datastream for BigQueryWhat are the core principles behind Google data centers?Solving for Accessible Phone Calls | Built by Student DevelopersMedical natural language processingIntroduction to GKE cluster modesUse case: getting started with Google CloudWhat is Automatic DLP?Introduction to image generation