Azure Postgres connection issue from Looker Studio

Looker Q&A Looker Studio
1

Hi,

I am currently having connection issue to Azure postgres from Looker Studio. The connection was successful using the Certificate PEM file given from Microsoft (DigiCertGlobalRootCA.crt.pem) file for more than 1 week, but now Looker Studio suddenly failed to connect to the db. No one is changing the data source connection. I checked the IP Whitelist and the Looker Studio’s IP address range (142.251.74.0/23) already exists in the list.

I also tried to connect to the same azure postgres db using other client such as PgAdmin 4 or DataGrid app, or using .net application, and they are all working fine without issue. So, currently only from Looker Studio is having the issue.

The strange thing is that few months ago, I also tried to connect to different azure postgres db, and the connection also sometimes working and sometimes not even with the same certificate, username and password. Not sure if this is an issue from Google, or Looker Studio or the Connector. Does anyone get the same issue? Can you please help how to resolve this?

Can you please help me what’s the other way to connect to azure postgres without using server certificate?

1 Like
2

Same issue here.
Except for me this never work even a single time.

3

try download the file and use this with SSL connection… it works for me for now.

4

I am experiencing issues connecting Looker to my PostgreSQL database hosted on Azure. Despite configuring the firewall to allow the following IP ranges:

  • 74.125.0.0/16
  • 142.251.74.0/23

and even setting the firewall to permit all IP addresses (0.0.0.0 - 255.255.255.255), the connection remains unsuccessful. I am seeking guidance on potential causes and solutions to establish a successful connection between Looker and my Azure-hosted PostgreSQL database.

5

try download the certificate called

If the link is not working, try find that “DigiCert Global Root CA” and download it from the internet. Use this certificate in Postgres SSL Configuration File and enable the SSL

mindlessmind_0-1732074345226.png
mindlessmind_0-1732074345226.png439×772 27 KB

6

Download the , tick enable the SSL and use / upload the downloaded DigiCert Global Root CA file into Postgres SSL Configuration file

7

search and download DigiCert Global Root CA file and use it with enable SSL

8

I got the same issue with my Azure Postgres database. I uploaded the certificate and I whitelisted all ip addresses (first only the google ones).

But nothing works. Anyone any clue?

9

At one point, I was able to connect, and I was able to see the database schema, but it immediately stopped working. That was very strange.
We also had issues with the Postgre driver in Dataflow.
We opted to do an ETL, bringing the data into BigQuery.

Regards