I am having issue connecting to my AWS RDS Mysql database through Looker Studio. The database is behind a vpc, so to access it I need to ssh tunnel through an ec2 instance. I can connect to the database from my terminal doing the following
ssh -i staging.pem ec2-user@ecx-x-xx-x-xxx.compute-1.amazonaws.com
then inside the ec2 instance, i run the following to connect to the database
mysql -h staging-reader.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com -P 3306 -u looker -p
In Looker Studio, I tried connecting using the MySQL connector with the following credentials
Hostname: staging-reader.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com
Port: 3306
Database: table
Username: Looker
Password: xxxxxxxx
Do I need to enable SSL and client authentication? I added 142.251.74.0/23 to the security group. What else do I need to do?