Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Cannot connect looker studio to Postgres Database hosted in Google Cloud SQL

Hello everyone,

I am trying to connect to Looker Studio my Postgres Database that is hosted in Google Cloud SQL using the PostgreSQL google connector for days and have the same problem: " Sorry, we encountered an error and were unable to complete your request. Error ID: 3323e234"

My database has SSL certificates.

Host Name: The P
ublic IP address found in SQL Instance
Port: 5432
Database:  foo-database
Username: postgres
Password: ****

I have ticked "Enable SSL" and "Enable Client authentication" and imported the certificates that I use to also connect to PGAdmin.

I have included the 142.251.74.0/23 address as instructed in the docs in the Authorized networks of my db.

I still cant connect and cant find why.

Any ideas?

Solved Solved
2 6 1,190
1 ACCEPTED SOLUTION

I had converted my client key with openssl to PKCS-8 but it didn't work. Someone gave me the solution that actually works in stackoverflow. For anyone interested:

https://stackoverflow.com/questions/78951870/cannot-connect-looker-studio-to-postgres-database-hoste...

View solution in original post