Alteryx - Snowflake connection when hosted on AWS EC2

[Srini96]

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]

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. 

[BrandonB]

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-Sta...