Unable to create BQ external connection to Cloud SQL in diffrent project

Google Cloud Database
1

Error creating Connection: googleapi: Error 400: CloudSQL instances must be in the same project as the query connection. CloudSQL instance project:

Can someone conform this the case and connection only work with Cloud SQL in same project. Is there any workaround without ingesting the data to BQ.

The documentation does not not have this a limitation. This is very surprising, when this feature is bundled with connecting to other external cloud providers.

1 Like
2

Hi @deb1234 ,

Welcome to Google Cloud Community!

BigQuery currently cannot connect to Cloud SQL instances in different projects.

  • This is a limitation, though not explicitly stated in all documentation.

Alternatives:

  • Ingest data into BigQuery for analysis.
  • Move Cloud SQL instance to the same project as BigQuery (if feasible).
  • Stay updated on official channels for potential future changes.
3

Can we ask to add this as limitation ( big/bold) in documentation.