Query related Google cloud SQL (POSTGRES)

Question

Hi Guys !!!
We are using GCP(Google cloud Sql using postgres) as our staging table in our upcoming project .In snaplogic i could not found any snap to connect for the same .
I tried using creating a postgres account buts its giving below error .
Snapshot GCP Error at snaplogic:

Snapshot PGADMIN where i can connect to Google cloud

Please help me how to connect to GCP using Snaplogic .

cstewart · Answer

When you do the validate, it is calling out from the Snaplex.  Where is your Snaplex located?  If is it a Cloudplex, then you may need to whitelist the IP addresses (see our documentation) from where the request will originate.

dmiller · Answer

See https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439213/Cloudplex+IP+Whitelist

cstewart · Answer

As long as you specify the RANGE (make sure you specify the /25 or /32 on the end of the address) as per that page, it should cover any of the available IPs.

rbikash7758 · Answer

Hi cstewart,
Thanks a lot for ur reply.
Could you please elaborate a bit more on whitelisting IP address means. If possible could you please also mention the link as well. It would be useful.
Pn:Our snaplex is a cloudplex type.

rbikash7758 · Answer

Thanks dmiller.
I will try out this for sure.

Forum Discussion

Query related Google cloud SQL (POSTGRES)

Recent Discussions

SFTP: Worked ok then settings changed not not working

SQS Consumer snap is ready all message at pipeline startup

Salesforce Update REST API Throughput

Using Windows Authentication with SQL Server Accounts

Preview not available for Flow snaps