Connecting google CloudSQL (SQL server instance) to BigQuery

[Eduardo Humberto]

Hello folks,

I have been looking around the internet and reading Google Cloud SQL documentation , trying to figure out a way to connect CloudSQL (SQL server instance) to Google BigQuery. I ended up with the federated queries, but this resource is not available for SQL Server instance. 

Does someone have faced the same problem or similar and have any tip to a feasible solution?

Best,

Eduardo

[David (Google Cloud Support)]

Hello,

Your statement about federated queries not supporting Cloud SQL Server is correct as the documentation states that it only supports MySQL 2nd generation and PostgreSQL instances.

If you refer to this StackOverflow post, the accepted answer mentions using some third party products to connect your Cloud SQL Server instance to BigQuery, or make use of Cloud Dataflow. The suggestions made there might interest you.

If you are specifically interested in using federated queries, then you may also open a Feature Request asking for federated queries to support Cloud SQL Server by following the instructions here; I currently do not see any requests of that nature yet, so opening a request may push the addition of that feature forward.