Cannot connect Looker Studio to Postgres Database hosted in Google Cloud SQL

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?

I face the same issue I solved passing the credential to the format that looker needs!

Try using this python code and use the new key

from cryptography.hazmat.primitives import serialization
from cryptography.hazmat.backends import default_backend

input_path = "client-key.pem"
output_path = "client-key-pkcs8.pem"

# read original key (PKCS#1)
with open(input_path, "rb") as key_file:
    private_key = serialization.load_pem_private_key(
        key_file.read(),
        password=None,
        backend=default_backend()
    )
# save in format (PKCS#8)
with open(output_path, "wb") as out_file:
    out_file.write(
        private_key.private_bytes(
            encoding=serialization.Encoding.PEM,
            format=serialization.PrivateFormat.PKCS8,
            encryption_algorithm=serialization.NoEncryption()
        )
    )
output_path