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?
The following ranges need to be whitelisted for Data Studio to work: https://developers.google.com/apps-script/guides/jdbc
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With