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

MariaDB (10.5.20) and LookerStudio cannot connect

Posted on 07-28-2024 02:48 AM
tohru
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I would like to connect to LookerStudio using the MySQL (developer: Google) connector.

8a62d8ed

An error will appear.

The DB is installed on AWS, and an SSH key is used for connection.

How can I connect?

 

0 3 336
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
dylantrose
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Hey Tohru,

I use the postgres connector a lot, and there are two major issues that I've come across that may help find your solution.

1. Ensure that your MySQL database allows incoming connection for Looker Studio. You must set it to allow Looker Studio's IP address to access your database. Their IP for MySQL:

142.251.74.0/23

2. I have found that connecting datasets with capital letters and spaces in the column names can be finicky. I recommend renaming all columns to be snake case. Also ensure that they only contain ASCII characters.

Checkout this link for more information: https://support.google.com/looker-studio/answer/7088031?hl=en&ref_topic=7332343&sjid=131251658247171...

Hope this helps!

Dylan

0 Likes

Posted on --/--/---- --:-- AM
tohru
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM 
thank you.
to the applicable DB
142.251.74.0/23
I tried allowing access and running it again.

However, this time another error occurred.
ID:31116663

What could be the reason?
0 Likes

Posted on --/--/---- --:-- AM
dylantrose
Silver 1
Silver 1
In response to tohru
Reply posted on --/--/---- --:-- AM

I cannot find the docs for this error id and I've never experienced it, sorry.

0 Likes