Tech-Discussion

MERGE ALL BY NAME If you are performing upsert operations, you need to provide a list of columns in the Update as well as the Insert clause. MS-SQL Server   We can achieve it as follows: In Snowflake, we can use  the same query as above; however, we can use   MERGE  as follows: For more details, refer to the  MERGE-By-Using-All-By-Name  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series

Stop or Cancel the Running Query While executing a query, we noticed it was taking unusually long to complete. In such situations, it’s important to know how to safely stop or cancel the execution to avoid performance bottlenecks and system impact. MS-SQL Server   We can achieve it as follows: In  Snowflake ,  we can use  CANCEL_QUERY  as follows: For more details, refer to the  CANCEL_QUERY  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series

ARRAY UNNEST - FLATTEN If you have an array saved in a table and want to generate each value in each row as below: MS-SQL Server   We can achieve it as follows: In  Snowflake ,  we can use  FLATTEN  as follows: For more details, refer to the  FLATTEN  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series