Override variables in SQL code recipe
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?
Answers
-
Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭
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/19964
Is it useful for your case?
Best regards
-
piyushk Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Adv Designer, Registered Posts: 55 ✭✭✭✭✭
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,
-
stevef Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1 Dataiker
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