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


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.


Location: Pune, Maharashtra, India

Comments

Post a Comment

Popular posts from this blog

Snowflake Vs MS-SQL - Series

Image
Snowflake Vs MS-SQL - Series Part 105 -  PIVOT - Custom alias to column name  -  Part 105 Part 104 - Row Comparison - HASH - Part 104 Part 103 - ORDER BY ALL - SORTING - Part 103 Part 102 - Last Value in the Series - Part 102 Part 101 - Trigonometry Functions - Geometry - Part 101 Part 100 - Split String into Different Columns - Part 100 Part 99 - Multi-Table Insert based on condition - Part 99 Part 98 -  Create Table If Not Exists - Part 98 Part 97 - Identify Data Type - SYSTEM$TYPEOF - Part 97 Part 96 -  Row Last Updated - ROW_TIMESTAMP   -  Part 96 Part 95 -  Date and Time - INTERVAL   -  Part 95 Part 94 -  BOOLAND_AGG   -  Part 94 Part 93 -  MERGE ALL BY NAME   -  Part 93 Part 92 -  Stop or Cancel the Running Query   -  Part 92 Part 91 -  ARRAY UNNEST - FLATTEN   -  Part 91 Part 90 -  Replace the String - INSERT - STUFF  -  Part 90 Part 89 -  Form the...
Read more

Snowflake Vs MS-SQL - Part 79 - Adding a comment to the Column of a Table

Image
            Adding a comment to the Column of a Table Suppose you are designing a new table, and you want to add a comment for the columns of that table, so that whoever uses this table will get some idea of the columns of this table. MS-SQL Server   We can achieve it by using a system-level stored procedure( sp_addExtendedProperty ), which uses Extended properties to allow you to store custom metadata: In  Snowflake,  we can use a similar approach by using the  COMMENT  clause as  below: For more details, refer to  COMMENT . Yogesh Shinde LinkedInProfile <<< Back   Next >>>   
Read more

Snowflake Key Concepts

Image
  Snowflake is a cloud-based data warehouse that offers scalable and secure storage and processing of structured and semi-structured data. Snowflake uses a shared-nothing architecture for parallel processing and offers native support for SQL as well as other programming languages such as Python, R, and Java   Snowflake’s unique architecture consists of three key layers: -           Database Storage -           Query Processing -           Cloud Services In Snowflake, they have done the decoupling of storage and compute.   Virtual Warehouse: -           A compute resource in Snowflake that processes queries and performs data loading and unloading. -           It can be independently scaled up or down based on demand. -   ...
Read more