Creating Snowflake tasks possible?
info-rchitect
Registered Posts: 186 ✭✭✭✭✭✭
Hi,
Is it possible to create Snowflake tasks using dataiku? My use case is looping through N products and creating a task for each, all tasks nearly identical except for the product ID being change in various places in the task.
EDIT: Yes it is possible. Using a Python partial recipe, I create the initial tables using the 'pre_queries' argument and handle the task creation in the 'post_queries' argument.
SQLExecutor2.exec_recipe_fragment(uld_all_ranks_distinct_psf, concat_sql, pre_queries=pre_queries, post_queries=post_queries)
thx
Operating system used: Windows 10
Tagged: