How to connect Google Data Studio with AWS RDS MySQL behind VPC?

Question

I have a AWS RDS MySQL database hosted inside VPC. I am having problem with connecting Google Data Studio since it's obviously outside the VPC. I have enabled Publicly Accessed option in the RDS but still can't connect, even from MySQL Workbench.

Anyone has successfully connect between AWS RDS MySQL inside VPC and Google Data Studio? What's the setup and configuration?

Answer 1

I have posted a similar question to connect MySQL & Google Data Studio (while having SSL enabled). My latter question still needs to be answered, but I actually got MySQL Workbench to work with our AWS RDS MySQL-DB.

Steps:

• Add SSL access to the AWS's MySQL database user as recommended in the documentation: GRANT USAGE ON *.* TO 'encrypted_user'@'%' REQUIRE SSL;
• Add your current IP address to the AWS instance's firewall-whitelist, to allow for remote MySQL DB access.
• Add hostname, port (3306), encrypted_user (created above) and password.