community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Product Suggestion: Post Create SQL Statement for Snowflake Loader

Meteoroid

Hi Team,

 

Just throwing this out there that it'd be great to have the Post Create SQL Statement option in the Snowflake loader as is available on Input and Output tools and In-DB tools.

 

The reason for this is that we use the "alter warehouse "COMPUTE_WH" suspend" in the post script. This turns the warehouse off and saves $$$

 

A loader which takes 15 seconds to run, can still cost 5 minutes of credits.

Highlighted
Alteryx
Alteryx

Hi @RuttanB ,

interesting idea ;) I think we can add it into feature versions of the loader.

 

Ondrej

Connect Team

Meteor

What version of Alteryx are you using?  We're on 2019.1 and do have the 'Post Create SQL Statement' option when using the Snowflake Bulk Loader. 

Meteoroid

We're using the ODBC driver, and again on the Input/Output tools we have the Post Create SQL Statement and we us it.

 

Best practice is now, for us, is to a block after the Input and put a block before the Output as well.

 

But specifically the request was for the Snowflake Loader for Connect.

Meteoroid

thank you

Labels