Tech-Discussion

Show Columns of a Table Sometimes, we need to check the columns of a particular table. MS-SQL Server We can achieve it as follows: In Snowflake , we can  use SHOW_COLUMNS  as follows: For more details, refer to the SHOW_COLUMNS section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series        

Extract a Year from the DATE Sometimes, we need to extract the year component from a given date. MS-SQL Server We can achieve it as follows: In Snowflake , we use EXTRACT as follows: For more details, refer to the EXTRACT section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series      

Parse and Save XML Sometimes, we need to parse an XML file and save it in a table. MS-SQL Server We can achieve it as follows: In Snowflake , we use PARSE_XML  as follows: For more details, refer to the PARSE_XML section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series      

Convert Data Type - Decimal to Integer Sometimes, for various reasons, we need to convert decimal values to integer values. MS-SQL Server We can achieve it as follows: In Snowflake , we use EXTRACT as follows: Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series      

Filter Columns in Result Grid When the result set contains numerous columns, it becomes challenging to identify the columns we need. MS-SQL Server The result grid does not allow us to select only the required columns. As a workaround, we need to explicitly limit the columns in the SELECT clause. In Snowflake , we use the filter provided in the Result Grid  as follows: Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series