Alteryx - Snowflake connection when hosted on AWS EC2
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Best Practices
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...