Options to bulk load Alteryx output into Snowflake and post SQL with In DB tools?

[alysalow]

Hi, 

I am looking to migrate at least 50MBs of data from over 100 files via Alteryx to Snowflake tables. I would like to know what are the most efficient way to load the tables into snowflake.

Secondly, what is the work around for the post SQL query in the output tool for In DB output?

Thanks!

[mceleavey · Accepted solution]

Hi @alysalow ,

You can find out more about bulk loading to Snowflake below:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Snowflake-Bulk-Loader-How-Local-Sta...

https://help.alteryx.com/20221/designer/snowflake

https://www.alteryx.com/-/jssmedia/project/archive/drupal/2021-01/snowflake_whitepaper.pdf

I hope this helps,

M.