How to connect Google Data Studio to Google Cloud SQL

6
votes

I have a Google Cloud SQL database that I can connect to with my SQL client. However, I have not been able to connect Google Data Studio to the Google Cloud SQL database with the Cloud SQL data source. I have the IP address and credentials from Google Cloud SQL.

My guess is that Google Data Studio cannot connect to Google Cloud SQL because I need to add an IP address to allow the traffic into Google Cloud SQL but Google Data Studio does not have or does not publicize an IP range.

Has anyone had success connecting to Google Cloud SQL using the Cloud SQL data source in Google Data Studio?

2
google-cloud-sql
Take a look at this article: support.google.com/360suite/datastudio/answer/… – Kamran
Did you have the chance to add the CIDR mentioned in the Help Center article provided by @Kamran ? – George
@George yes, doesn't work – analyticsPierce
Are you getting any error messages while trying to connect? Which connector are you using? – George
To confirm, you added each of the listed IPs/Ports to your Cloud SQL access list ? If so, are you using First or Second generation Cloud SQL instance. Also is your IP IPv4 or IPv6? You may want to also consider making a new use specifically for this connection. – Jordan

2 Answers

3
votes

Since August 2017, Google Data Studio connects natively to Google Cloud SQL databases:

The current version of the connector no longer requires whitelisting, and it provides encryption; however, to use these features, you must create a new data source using the Google Cloud SQL connector.

See Google Cloud SQL connector in help for detailed description on how to create a connector.

3
votes

The following ranges need to be whitelisted for Data Studio to work: https://developers.google.com/apps-script/guides/jdbc