Is there anyway I can connect to Cloud SQL (SQL Server) with disabled public IP from BigQuery or Data Studio?

Question

I have my database in Cloud SQL (SQL Server). The public IP is disabled.

I wanted to run some select queries on this database based on which I want to create a dashboard on Data Studio.

I tried following two approaches:

• Cloud SQL federated queries: Using BigQuery we can connect to Cloud SQL, but this is limited to MySQL and PostgreSQL. Link
• Using MS SQL Server Google Connector: But I am not able to connect to my database since it is not public.

Is there anyway I can connect to Cloud SQL (SQL Server) with disabled public IP from BigQuery or Data Studio?

Answer 1

As Suggested by Guillaume, you cannot perform federated queries unless you're querying a PostgreSQL/MySQL instance or have a public IP.

However, in your scenario you can try replicating your data from SQL Server to BigQuery using Cloud Data Fusion as per this Documentation and then perform queries in BigQuery.

Answer 2

No, you can only perform BigQuery federated queries if you use:

• PostgreSQL or MySQL
• Have a public IP

You have none of 2.

For datastudio, it's an external tool, not attached to your project/VPC, and so, you can't access your database without a public IP.