Unable to connect to Postgres from cloud data fusion pipeline

[iamnicks96]

Hi All,

We are creating a cloud data fusion pipeline which will import data from a postgres db and store it to GBQ. our Postgres is hosted on Google cloud itself and below is the networking configuration of our db:

We have to whitelist our IP from which we are trying to connect to PostGRE. But we have also checked the option which will allow Google services to connect to the postgres db with a private IP:

Yet when we are trying to connect to this postgres db we are unable to do so, tested with both public and private IPs, error is shown below:

Can any of you guys know what can be the issue here? also does anyone know from which IP google is trying to connect to this postgres db to that we can whitelist that IP and able to connect to postgres. Thanks

[lsolatorio]

Hi @iamnicks96 ,

Thank you for expanding awareness to our community.

I understand that you are having challenges integrating PostgresDB and BigQuery, however, Google Cloud’s published documents do not specifically guide us with your use case. This may be an IAM configuration related issue.

Here are some reference materials that may help you:

• IAM references for Cloud SQL
• About connection options
• Configure VPC Service Controls
• Cloud SQL Admin API error messages

Hope this helps.