This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Looker studio My Sql Connection issue

Posted on 06-11-2024 05:18 AM
Saiarjun
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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

2.  MySQL db hosted on Cloud 

Saiarjun_1-1718107626701.png

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

- Please help 

 

0 2 1,221
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
marybells
Staff
Reply posted on --/--/---- --:-- AM

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.

0 Likes

Posted on --/--/---- --:-- AM
ArkadyZagdan
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM
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)
 
0 Likes