Querying Cloud SQL from BigQuery

Опубликовано 21 октября 2020, 23:00

Codelab to set up a Cloud SQL database → goo.gle/3m3Kn92

Want to analyze data residing in Cloud SQL from BigQuery, without copying or moving it? In this video, we not only show you how to set up a Cloud SQL connection resource in BigQuery, but we also show you how to query the connection using the EXTERNAL QUERY function. Watch to learn how you can utilize BigQuery’s federated queries with Cloud SQL!

Timestamps:

0:00 - Intro
0:45 - Enable the BigQuery connection service
1:21 - Configure the Cloud SQL instance
1:58 - Set up the connection resource in BigQuery
3:17 - Grant permission to connection users
3:41 - Example federated queries
5:00 - Next steps

Supported regions and compatibility → goo.gle/2Hkh5EA
Documentation for Cloud SQL federated queries → goo.gle/37syjdr

Subscribe to the GCP Channel for more content → goo.gle/38qHwkm
Watch the Getting Started with GCP Playlist → goo.gle/3bCFnUI
Watch the Getting Started with BigQuery Playlist → goo.gle/2EsHrTs

Product: BigQuery, Cloud SQL; fullname: Alicia Williams;

#GetStartedWithGoogleCloud