Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I have Snowflake connection with warehouse defined as variable. I am overriding this variable at project level, so that all recipes run on project level configured warehouse.
For few SQL recipes, I want to override the warehouse variable and use larger warehouse. Is there a way to do so in SQL recipes?
Hi,
If you search this community, you will find this other thread, https://community.dataiku.com/t5/Using-Dataiku/Multiple-Snowflake-Warehouse-in-Single-Connection/m-p...
Is it useful for your case?
Best regards
Hello Manuel,
Thank you for the reply. I read the community link shared by you, and it is having few points that I am aware of. But how can I override variables in SQL query code recipe.
Thanks,
Hi,
OK looks like you are familiar with the basics of variable expansion, if you want to use that to alter a warehouse from a SQL code recipe then you can simply use standard Snowflake notation. For example if you wanted to resize you could write:
ALTER WAREHOUSE MY_WH SET WAREHOUSE_SIZE = MEDIUM;
Hope that helps,
Steve