cancel
Showing results for 
Search instead for 
Did you mean: 

Query related Google cloud SQL (POSTGRES)

rbikash7758
New Contributor III

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:
GCP%20Snap

Snapshot PGADMIN where i can connect to Google cloud
GCP-PGADMIN

Please help me how to connect to GCP using Snaplogic .

7 REPLIES 7

rbikash7758
New Contributor III

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 :
IP

POSTGRES Cloud Connection snapshot :
IP2

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

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
New Contributor III

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 .

IP7

Thanks a lot for your help !!!