Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

Creating Snowflake tasks possible?

info-rchitect
Level 3
Creating Snowflake tasks possible?

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

0 Replies