Securely connect to AWS-hosted database

I want to use Google Looker to connect securely (i.e. password not sent in plain text) to a database hosted on AWS that is not directly accessible from the Internet. Is it possible to do so (e.g. via an AWS load balancer)? Or is Google Looker designed only to be used with databases that are either directly accessible from the Internet or hosted within GCP?

Solved Solved
0 4 996
1 ACCEPTED SOLUTION

Ah, gotcha. In that case, the information you're looking for is on the Connect to Amazon Redshift page.

Firewall and database access

To allow Looker Studio to connect to and query databases that are behind a firewall, you will need to open access to one of the IP addresses shown below. You may also need to configure your database to accept traffic from these addresses. Consult the documentation for your specific database for instructions on how to do this.



Private IP connections aren't supported for Looker Studio. You'd have to open the database to connect to the Looker Studio IP addresses over the public internet.

If that doesn't work for you, I recommend creating a feature request!

View solution in original post

4 REPLIES 4
Top Labels in this Space