Connecting Google Data Studio to Render Postgres Instance

#1
#2

Hi Scott,

It looks like Google Data Studio requires SSL to connect to a Postgres instance. I was able to get this working by doing the following:

  • Fill out the database authentication fields. The database, username, and password can be found on your Render dashboard’s database page. The host will be either oregon-postgres.render.com for U.S. or frankfurt-postgres.render.com for EU. The port will be 5432.
  • Click the Enable SSL checkbox
  • Fetch the server cert by running this script, supplying the host name of the Render server. python postgres_get_server_cert.py oregon-postgres.render.com > server.crt Upload server.crt to Google Data Studio as the server certificate.
  • Generate a public/private key using openssl req -newkey rsa:2048 -nodes -keyout domain.key -out domain.csr
  • Upload domain.csr to Google Data Studio as the client certificate and domain.key as the Client Private Key.
  • Click authenticate

You should now be able to access your Render Postgres instance from Google Data Studio. Let me know how this works for you!