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.
Operating system used: Windows 10