Now that we have a Snowflake Bulk Loader option, it would be great to utilize the built-in Snowflake internal staging. This eliminates the need for an end-user to have the technical know-how or access to IT resources to utilize a separate S3 bucket and generally reduces friction in the process.
There was pretty widespread support in the original Bulk Load thread: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Snowflake-Bulk-Loader/idi-p/105291/page/2#comments
Still quite overdue. Seems pointless to require users to incur the costs and hassle of a separate S3 bucket to use bulk-loading in S3. Makes the feature useless for a lot of users.
+10! WAY overdue now. I'm using version 2018.4.5 and have spent considerable time finding workarounds to this colossal oversight. These including Python, R, and SnowSQL command line. All able to use the PUT FILE (into local stage) command that Alteryx and the Snowflake console are unable to use. They work, but very difficult to integrate them into a workflow.
How can we push this idea further into review by the alteryx team? We badly need this one as well...
Can we get this ASAP please? Is really needed
Thank you for your post and contributing to the Alteryx Community! This feature will actually be going into beta in the near future and will be available to anyone who's joined our Beta program to test. We're also looking to implement the feature into our main product once we have received the proper feedback, so this feature should be available in the main product in the near future.
If you're interested in joining the beta check out our Join the Beta program here!
Exciting to see status changed to coming soon!!! Do we have a timeline on when this becomes production? Awaiting patiently.. 🙂 Thanks...
There is a beta available already for those interested. Please, join the beta program if you want to give it a try, we will be grateful for a feedback!
the link posted by @KylieF says "This opportunity is not available."
@fpinchon
Hello! Apologizes for the delay, that error in the beta program page should now be fixed, and you should be able to sign up no issue!
Looking forward to this one! Any timelines on the release date/version? We are looking to start using the AWS Bucket for the Snowflake Bulk Load but keys are a challenge due to company policies. I would wait for this one!
Hi @jineshnp31,
We're glad to see people excited for this feature! While we cannot provide timelines or release dates at this point, this feature is in beta currently and in the Coming Soon status, so we're looking have it available to the near future.
Is there a reason this was not included in the final 2020.2 release having been in the Beta? The lack of this feature is totally blocking our attempts to move our data to Snowflake and is extremely frustrating 👎🏻
Hi @robsuddaby,
While we're excited to release this feature, we couldn't include it in the product as it isn't quite ready for production environments yet, which is why we placed it in the beta program. However, the feature is coming soon and we look forward to including it in a near future release!
Currently, to upload large amounts of data from Alteryx to Snowflake, we need to connect using the Snowflake bulk loader which involves inputting an AWS access and secret key which is not static. Is there a way to add a feature to allow Alteryx to connect directly to the internal stage Snowflake S3 bucket?
Hi @balajilolla! Thank you for your feedback!
Just to confirm, is your request of using the internal stage feature in snowflake similar to this idea? https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Snowflake-Bulk-Loader-Utilize-built-in-Snowflake-Stage-Instead/idi-p/368187
Hello @KylieF . Yes this is the one. Thank you for pointing me to this link
Thank you for your feedback and support!
We're excited to say this feature has officially moved out of beta and is now available in the latest version of Alteryx, 2020.3, which is now available for download! Be sure to check it out and let us know what you think in the Designer Discussions board.