How to connect Postgres managed database as a datasource in Google Data Studio

Hello, I want to connect Postgres managed database to google data studio but I get an error while trying to establish a connection.

any guidance will be helpful.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Rajkishore J
DigitalOcean Employee
DigitalOcean Employee badge
June 28, 2021
Accepted Answer


Please follow the below steps to connect Postgres Managed database as the data source for google data studio

  1. Downloaded the CA certificate for your DigitalOcean instance from the console ( this will be a Server certificate)

  1. Generate client public/private keys pairs

Make sure you have OpenSSL installed on your operating system. OpenSSL will be used to generate client-side public/private key pairs.

openssl genrsa -out rsaprivkey.pem 2048
openssl rsa -in rsaprivkey.pem -pubout -outform DER -out rsapubkey.der
openssl pkcs8 -topk8 -inform PEM -outform DER -in rsaprivkey.pem -out rsaprivkey.der -nocrypt
  1. To connect your DO PostgreSQL as a data source in Data Studio

  • Select “Data Sources” on the left followed by the blue (+) on the bottom right corner to add a new data source. Please follow the next set of prompts to agree to google terms and conditions.

  • Select “PostgreSQL” as the data source type on the left and proceed to “Authenticate” DigitalOcean PostgreSQL. Follow the next set of steps to authenticate with your Google account.

  • Under the “Basic” settings, input the values for host, port, database, username, and password. (Note: these values can be obtained from the DigitalOcean console)

  • Remember to enable SSL for over-the-wire encryption of data and enter the cert and key files.

  • Finally, click “Authenticate” to authenticate with the DO PostgreSQL database server.

  • After authentication with the database, you can proceed to query data from it

I hope this helps!

Regards, Rajkishore

Rajkishore J
DigitalOcean Employee
DigitalOcean Employee badge
January 26, 2022

Hi All,

Note: the private key should be in PKCS8 format, so if you have supplied rsaprivkey.pem; you will get the below error.

“Please make sure that the private key is in PKCS8 format. Error ID: 8dc032ae”

Add PostgreSQL SSL Client Configuration Files as below :

Server certificate: ca-certificate.crt

Client certificate: rsapubkey.der

Client private key: rsaprivkey.der

I hope this helps!!

Regards, Rajkishore

Rajkishore J
DigitalOcean Employee
DigitalOcean Employee badge
November 2, 2021

For MySQL, refer to the below link :

Will suggest trying without “Enable SSL”.

Regards, Rajkishore

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Featured on Community

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more
DigitalOcean Cloud Control Panel