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
- 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.crtUpload
server.crtto 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
domain.csrto Google Data Studio as the client certificate and
domain.keyas 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!