In less that 15 minutes we'll show you how to securely replicate tables from your private PostgreSQL database into your #snowflake data cloud. There's no need to introduce security risks by making your systems accessible from the public internet, no need to change firewall rules to allow ingress, no managing of IP allow lists, and none of the complexity of getting services like Private Link and Secure Connect setup. Just a secure point-to-point connection between your systems, with the added benefit of mutually authenticated nodes that encrypt all of your data end-to-end!

www.ockam.io/

A quick start guide for ‪@snowflakedevelopers‬
www.ockam.io/blog/snowflake-pull-postgres

Ockam on the ‪@SnowflakeInc‬ Marketplace:
app.snowflake.com/marketplace/listing/GZTYZXRGOHF/…

Ockam node for Amazon RDS Postgres in the ‪@amazonwebservices‬ Marketplace: aws.amazon.com/marketplace/pp/prodview-zjugwdx5hp2…

00:00 Intro
00:36 What options are there to securely connect systems?
03:18 How to securely connect two private systems
04:55 Installing the Pull from PostgreSQL native app from Snowflake Marketplace
05:55 Setup Ockam & enrolling as an admin
07:17 Enabling Postgres logical replication
09:39 Turn on Postgres table replication
10:31 Creating the AWS RDS Postgres node & relay
14:19 Adjust RDS security groups
15:24 Configuring the Snowflake node
16:55 Granting required privileges
17:57 Mapping Postgres tables to Snowflake tables
19:17 It's done
19:39 See the streaming data in action!
20:53 Recap on everything we setup, and why it's secure