Alteryx - Snowflake connection when hosted on AWS EC2

Question

Hello,

I have recently hosted Alteryx on an EC2 instance. I'm looking to establish a connection to snowflake db to load data.

What would be the best practice to do this? I'm also concerned about data security when connected to snowflake. Would this be a secure connection?

Thanks in advance!

BrandonB · Answer

Here is an additional write up on the bulk loading capabilities: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Snowflake-Bulk-Loader-How-Local-Staging-Works/ta-p/730720

BrandonB · Answer

Here is the documentation on setting up Snowflake connections: https://help.alteryx.com/current/designer/snowflake

The same would need to be done on Alteryx Server. You will definitely want to leverage the bulk loading capabilities for write speed. It uses an Amazon S3 bucket to stage then load the data into Snowflake.