Looker studio My Sql Connection issue

Looker Q&A Looker Studio
1

Good Day All,

I have requirement to connect mysql DB. Let me come with Step -wise.

  1. Open Looker studio selected DB connecter Cloud SQL for MySQL and filling the details after that clicking authenticate and getting this error

Saiarjun_0-1718107216982.png
Saiarjun_0-1718107216982.png941×261 20 KB

  1. MySQL db hosted on Cloud

Saiarjun_1-1718107626701.png
Saiarjun_1-1718107626701.png584×117 7.5 KB

we have private ip but no public ip and instance connection name details

  • Please help
2

Hi @Saiarjun ! To allow Looker Studio to access data in Cloud SQL and make queries against this data over a private connection, select the Enable private path option under Google Cloud services authorization in your Cloud SQL for MySQL instance settings. Hopefully, this helps resolve the issue.

3

Hi Saiarjun.

I understand you would like to connect MySQL instance to your Looker Studio report.
While it sounds tempting to use the connector I strongly advise you to not do so, especially when this is a production and transactional database and not replica.

If the final goal is to create some advanced reporting its always better to create a replication process of your tables into BigQuery. Having in mind MySQL is hosted on GCP it would be easy to do it using DataStream.

Here is a short tutorial on whhatts DataStream and hhow to execute it for MySQL GCP hosted:

https://cloud.google.com/datastream/docs/sources-mysql

After setting up a Datastream replication to BigQUery directly and then transforming your data using SQL you will benefit by:

  • lower costs of theh final solution
  • No hotspots on your production database (huge queries run into Looker studio may cause problems on your transactional environment and make it slower to work).
  • Last but not least Dashhboard in Looker Studio will benefit from BI Engine and it will greatly improve it’s performance and final user satisfaction:)

However, in some rare cases when you only need a one page report based on a simple table with not much joins included, and not oftenly updated it’s also a feasible solution.

I hope it helps:)
Arkady Zagdan
(URL Removed by Staff)