What Snowflake ODBC Driver should I have in order to use bulk load

Question

I currently have Snowflake Driver 2.21.06.00 and I don't see the option to select Advanced Options where typically I should be able to select Retrieve Entire Results Into Memory.  Based on the current help article (https://help.alteryx.com/current/designer/snowflake) it states that the Snowflake Driver is only supported for the Snowflake driver 2.20.1.

To top it off, Snowflake Driver 2.20.1 is no longer available to download. I would appreciate any help in resolving this confusion. Thank you

MichalM · Accepted Answer

@aminhas

The bulk load should work with your driver version as well. The Supported driver suggests that this was the version the feature was tested with.

When configuring your Output, choose the bulk option

Data Source name should pick up your available Snowflake DSN. If you're on Alteryx v2020.3, you will be able to use the Local staging as well to perform the bulk load