CODEWITHSUNDEEP
postgresqlamazon-rdslooker-studio
claptimes
claptimes

Reputation: 1717

How can I connect Google Data Studio to an AWS RDS Postgres instance?

When I go to make a new data source in Data Studio, I'm prompted to enter the client/server certificates to make a secure connection. Where can I get this client certificate and key? How can I allow Google Data Studio to connect to my RDS instance?

enter image description here

Upvotes: 2

Views: 4370

Answers (1)

claptimes
claptimes

Reputation: 1717

Do the following:

  1. Add the Google IP addresses to your RDS security group inbound rule list.

  2. Generate a self-signed cert. This answer provides instructions.

openssl req -newkey rsa:2048 -nodes -keyout client.key -x509 -days 365 -out client.crt

  1. Get the correct server PEM file for your region from AWS

  2. Add your database user information to the form and attach your client.crt, client.key and AWS pem files. enter image description here

Upvotes: 2

Related Questions