Tried to connect Google Looker and Zing to my postgres database and it doesn’t work with my external connection url.
On Zing, this is the error I’m getting:
So I add ?ssl=true as I read online somewhere and the error is different.
How can I connect? It’s weird because copy and pasting the exact same variable into TablePlus, it works fine. I can browser my database locally from my machine.
But both of these services (Google Looker and Zing) don’t work.
According to the screenshot at PostgreSQL | Zing Data Documentation , there is an SSL/TLS switch you have to enable at the bottom of that panel you screenshot.
Woah how did I not see that - thank you. Zing allows me to submit with SSL toggled ON, and empty cert fields. 
Google Looker requires some cert to be uploaded. Where do I find this?
This requirement of Google Looker’s is very annoying. I’ve never used any other product that requires it, and its made worse by the fact that certificates rotate once every 2 months, never longer than once every 3 months.
If it is in fact the server’s certificate you require, then you’ll have to follow the instructions described by How to examine PostgreSQL server's SSL certificate? - Database Administrators Stack Exchange to get the certificate, save it to a file, and use that in Looker’s configuration.
That’s good to know - damn that does sound annoying.
What BI tool have you used that works well with Render’s Postgres? Open to alternatives without these headaches.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.