I am currently trying to access a Cloud SQL database from another team as to be able to query it via BigQuery federated queries.
Sadly, as they are in a different project than my BigQuery data warehouse, I cannot use federated queries.
The solution I envisioned would be to simply create a read replica of this database on my project, and use federated queries on it.
Even though the documentation does not seem to forbid this, there does not seem to be any documentation about how to proceed with this.
I have tried using the gcloud command:
gcloud sql instances create <my-replica> --master-instance-name <source instance> --project <source project>
The one above creates a read replica, but in the source project which is no use for me
gcloud sql instances create <my-replica> --master-instance-name <source instance> --project <destination project>
This one raise a 404 as it seems to be looking for an instance named inside of the .
Is there a straightforward way of creating this read replica instance that I am missing ?
The only other way I managed to find in the documentation would be to create my replica as external replica, but it seems far harder to configure.