This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Redshift and SnapLogic

gg433
New Contributor III

โ€Ž04-22-2020 08:24 AM

We are trying to stand up a new Redshift environment and want to be able to connect and run pipelines with SnapLogic.

Corporate security rules require us to launch the Redshift cluster in a private subnet, no NAT or Internet Gateway, all access through firewall rules. Do we absolutely have to use a Groundplex, can we do it in a cloudplex? If we have to use a Groundplex, can we use an existing Groundplex already running in our SnapLogic account?

Thanks!

0 Kudos
3 REPLIES 3

mina
Employee
Employee

โ€Ž04-22-2020 10:17 AM

Hi Gary, if the cluster allows whitelisted addresses, you could whitelist our Cloudplex ips to allow access.
And yes you can use your existing Groundplex.
Thanks,
Mina

0 Kudos

gg433
New Contributor III

โ€Ž04-23-2020 09:39 AM

Do we need to whitelist both directions (inbound and outbound), from VPC to SnapLogic and SnapLogic to VPC?

0 Kudos

mina
Employee
Employee
In response to gg433

โ€Ž04-23-2020 11:42 AM

Hi Tony, If the Cluster is Publicly accessible,
just whitelisting SnapLogic Cloudplex ips on VPC side.
If using the Groundplex, on the VPC, you will also need to
add a new rule with Redshift as the type, TCP as the protocol, the port 5439 (the default) and the Groundplex nodesโ€™ ip
to allow them to access.
If Publicly accessible is false, It can only be accessed from within the VPC.

0 Kudos