Connecting Google Data Studio to Render Postgres Instance

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 for U.S. or 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 > 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!