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 Public IP address found in Google Cloud 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?
2
You are probably using a more recent version of PostgreSQL that is not supported by Looker Studio. As of this moment latest supported version is 14: https://support.google.com/looker-studio/answer/7288010?hl=en#zippy=%2Cin-this-article
They seem to have recently added support for version 15 based on our tests though this is not documented yet.
1