Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect Google Data Studio to Google Cloud SQL

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?

like image 211
analyticsPierce Avatar asked Aug 31 '16 03:08

analyticsPierce


2 Answers

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

like image 50
Vadim Avatar answered Oct 20 '22 21:10

Vadim


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.

like image 44
FelixEnescu Avatar answered Oct 20 '22 23:10

FelixEnescu