Source
Migrating project definition files from version 1.x to 2.0
Go to your project directory that contains the version 1.x snowflake.yml file. Enter the snow helpers v1 - to - v2 command.
How to rewrite SQL Server OUTER APPLY queries in Snowflake
ISSUE: The APPLY operator in SQL Server basically does the same thing as LATERAL JOIN in Snowflake does. We can simply replace CROSS APPLY with INNER LATERAL JOIN to get the SQL Server query to work in Snowflake.