Tech-Discussion

Row Last Updated - ROW_TIMESTAMP Many times, you have to find out when the record was updated last time MS-SQL Server We need to create a column in a table, like modified_date, which will store the value of datetime: In  Snowflake ,  we can use a similar approach as above; however, we can use  ROW_TIMESTAMP  as follows: For more details, refer to the  ROW_TIMESTAMP  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series  

Date and Time - INTERVAL Often, you need to add a duration/interval to an existing date. MS-SQL Server We can achieve it as follows: In  Snowflake ,    we can use a similar approach as above; however, we can make use of the new data type  INTERVAL  as follows: For more details, refer to the  INTERVAL  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series

BOOLAND_AGG If you want to identify values that are the same as the given criteria. In the table below, all orders have an order_status of SHIPPED. ORDER_ID   ORDER_STATUS 1         SHIPPED 2         SHIPPED 3         SHIPPED 4         SHIPPED MS-SQL Server We can achieve it as follows: In Snowflake,  we can use  the same query as above; however, we can use   BOOLAND_AGG  as follows: For more details, refer to the  BOOLAND_AGG  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series