Hello, I’m trying to connect from Looker Studio to my postgres database and I keep getting an error, It can’t connect. Has anybody accomplished making the connection?
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!
Hi there,
I just tested this and it seems to be all working as expected:
Note that you need to make sure that you check the ‘Enable SSL’ checkbox and upload your Postgres certificate. You might have to rename the certificate and change the .crt extension to .pem in order for Looker Studio to accept the certificate.
Let me know how it goes!
- Bobby
Heya @befdf20056c24eee99d94b8df295be,
Yes, I can confirm I’ve also tested this and confirm it’s working.
Can you share what options you’ve selected in the Looker Studio? Have you allowed your IP address as well?
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.