Query related Google cloud SQL (POSTGRES)

[rbikash7758]

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 .

[rbikash7758]

Hi Craig and Diane,

First of all thanks a lot in assisting me !!!

I have tried the above mentioned steps of IP Whitelisting and now i am able to connect but as per google below mentioned link they say the IP address may change occasionally so they advice not to use IP Whitelisting technique to connect GCP.
https://help.gooddata.com/display/doc/IP+Whitelisting

My GCP IP Whitelisting snapshot :

POSTGRES Cloud Connection snapshot :

But here my question is will the IP’s of snaplogic cloud will be always the same or it will change .

For example connecting to local postgres i also have added my system IP in the list but that use to change as well and accordingly i have to change in google cloud sql but in production i can’t do the same .

Please advise if i can use above link snaplogic cloudplex IP and it will not change as per below link :
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439213/Cloudplex+IP+Whitelist

[cstewart]

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]

Hi Craig,

Updated the IP address at google cloud as you have suggested .Please have a look and let me know if that seems good to you .

Thanks a lot for your help !!!