Snowflake recently obsoleted the Behavior Change Policy, impacting our ability to generate our Snowflake SQL UDFs. This change causes SQL UDFs to fail when used in dynamic table definitions.
We are currently investigating the issue and working on deploying a fix. If you are impacted by this issue, we recommend writing the Snowflake UDF definitions at this moment as a temporary fix.
Instructions on how to write the Snowflake UDF and UDTF code can be found in this community post.