Product Suggestion: Post Create SQL Statement for Snowflake Loader

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.

Settings

Tips and Tricks

Accepted answers

OndrejC

Hi @RuttanB ,

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

Ondrej

Connect Team

All comments

OndrejC

Hi @RuttanB ,

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

Ondrej

Connect Team

danners

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.

RuttanB

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.

RuttanB

thank you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703