Tech-Discussion

Posts

Snowflake Vs MS-SQL - Part 115 - Recursive View - Hierarchy

September 20, 2026

Recursive View - Hierarchy Sometimes data is stored in a hierarchical structure within a table. To display the complete lineage or parent-child relationship, you can use a recursive query. MS-SQL Server We can achieve it by creating a CTE as follows: In Snowflake, we can use a similar approach as above; however, we can make use of a Recursive View as follows: For more details, refer to the Recursive_View section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 114 - Period Data Type

September 12, 2026

Period Data Type In the warehouse, you usually save a record with start_date and end_date. If you want to filter a record based on these dates, then you have to use both date columns. MS-SQL Server We can use a WHERE clause as below: In Snowflake, we can use a similar approach as above; however, we can use the PERIOD DATA TYPE as follows: For more details, refer to the Period-DataType or Period-Function sections. You can see multiple use cases for the PERIOD data type. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 113 - Clear the cache

September 05, 2026

Clear the cache When you are working on query performance, you have to clear the cache. MS-SQL Server We can achieve it as follows: In Snowflake, we can use ALTER_SESSION or ALTER WAREHOUSE as follows: Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 112 - Show Columns of a Table

August 29, 2026

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

Snowflake Vs MS-SQL - Part 111 - Extract a Year from the DATE

August 22, 2026

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

Snowflake Vs MS-SQL - Part 110 - Parse and Save XML

August 15, 2026

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

Snowflake Vs MS-SQL - Part 109 - Convert Data Type - Decimal to Integer

August 08, 2026

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

Snowflake Vs MS-SQL - Part 108 - Filter Columns in Result Grid

August 01, 2026

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

Snowflake Vs MS-SQL - Part 107 - Create or Alter Table - Add Column

July 18, 2026

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

Snowflake Vs MS-SQL - Part 106 - Table Structure - Describe

July 11, 2026

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

Snowflake Vs MS-SQL - Part 105 - PIVOT - Custom alias to column name

July 04, 2026

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

Snowflake Vs MS-SQL - Part 104 - Row Comparison - HASH

June 27, 2026

Row Comparison - HASH When we need to compare data across all columns in two particular tables. MS-SQL Server We can achieve it as follows: In Snowflake , we use HASH as follows: For more details, refer to the HASH section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 103 - ORDER BY ALL - SORTING

June 20, 2026

ORDER BY ALL - SORTING When we fetch data, we sometimes need to sort it. If there are limited columns, then it is fine. Suppose there are multiple columns, then you have to mention the entire list of columns in an order by clause, which is a tedious job. 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 ORDER BY ALL as follows: For more details, refer to the ORDER BY ALL section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 102 - Last Value in the Series

June 06, 2026

Last Value Whenever we are sorting out the data and want to find the last value in the series. 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 LAST_VALUE as follows: For more details, refer to the LAST_VALUE section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 101 - Trigonometry Functions - Geometry

May 30, 2026

Trigonometry Functions - Geometry We rarely need to use trigonometric functions during calculations. MS-SQL Server We can achieve it as follows: In Snowflake , we use SIN as follows: For more details, refer to the SIN section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Part 100 - Split String into Different Columns

May 24, 2026

Split String into Different Columns Suppose your application stores the name of an employee as a full name, and while retrieving, you want to separate it out as first name, middle name & last name. MS-SQL Server We can achieve it as follows: In Snowflake , we can make use of SPLIT_PART as follows: For more details, refer to the SPLIT_PART section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Search This Blog