CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerygoogle-cloud-sql
Ameet
Ameet

Reputation: 341

Can we use Cloud SQL federated queries to insert data from BigQuery to Cloud SQL?

Can we use Cloud SQL federated queries to insert data from BigQuery to Cloud SQL

Upvotes: 1

Views: 1125

Answers (1)

Jaroslav
Jaroslav

Reputation: 742

Federated queries enables BigQuery to query data residing in Cloud SQL in real-time and introduces a new function: EXTERNAL_QUERY. Unfortunately, as per official documentation there are some limitations and one of them “The external query that will be executed in the source database must be read-only.“, means that you can’t use federated queries to insert data to Cloud SQL.

Upvotes: 4

Related Questions