Tech-Discussion

Create or Alter Table - Add Column You design a table to meet your current requirements, and after a few days, you might need to add an additional column to the existing table. MS-SQL Server We can achieve it by altering the table structure as follows: In Snowflake ,   we can use a similar approach as above; however, we can make use of ALTER  as follows: For more details, refer to the ALTER section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series    

Table Structure - Describe  Sometimes, we need to look at how a table is arranged to understand it better. MS-SQL Server We can achieve it as follows: In Snowflake , we use DESC  as follows: For more details, refer to the DESC section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series  

PIVOT - Custom alias to column name When we are performing a PIVOT operation, we must provide aliases for the generated columns. MS-SQL Server We can achieve it as follows: In Snowflake , we use   PIVOT  as follows: For more details, refer to the PIVOT section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series