IN-DB Pre and Post SQL Statements

[FkeetGuy]

Hi Team,

If it's implemented could someone steer me to the correct documentation please?

We use Snowflake and it'd be super handy to be able to do Pre and Post Sql statements from it. Even simple ones like 'USE WAREHOUSE QUERY_WH' 

This would allow us to effectively cost account to warehouses for the in-db processes. I've got a workaround for the Post Sql statement for Stage file loads, but again, it'd be great to have them in the tool.

thanks

[alexnajm · Accepted solution]

This is available in 25.1 - can you upgrade?

otherwise there’s a workaround in the idea for in-db pre sql that could work

[FkeetGuy]

I was the one that called out issues with 25.1 after upgrading and had to downgrade.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Recent-Upgrade-to-2025-1-Issue...

But thanks, I know there is a solution it's just waiting for me.

[alexnajm]

Very normal with the most up to date version in my experience, but yes hopefully a feature to look forward to soon enough!