Potential Bug: execute_recipe_fragment exeucting post-queries before main query is complete

info-rchitect
Level 6
Potential Bug: execute_recipe_fragment exeucting post-queries before main query is complete

Hi,

 

I have a Python recipe that has a main SQL query meant to write a Snowflake dataset.  I add a bunch of post-queries to handle permissions and view creation.  What I am seeing is the post-queries running before the main query is completed.  Is this expected?  From the documents, I believe it is not.

SQLExecutor2.exec_recipe_fragment(ws_unit_history, sql, pre_queries=pre_queries, post_queries=post_queries)


I expect the SQL in the post_queries argument to wait for the SQL in the sql argument to finish.  

thx


Operating system used: Windows 10

0 Kudos
0 Replies