Creating Snowflake tasks possible?

Options
info-rchitect
info-rchitect Registered Posts: 169 ✭✭✭✭✭✭
edited July 16 in Using Dataiku

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

Setup Info
    Tags
      Help me…