How to perform transpose of resultset in Snowflake

Below attached ss are the sample data of my join query, now I want to achieve transpose of this data as id, last updated, provider reference, building reference as my column names, and Val column as my data for the respective headers. Any help is much appreciated. Thanks.


posted on 04 Nov 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds


This has already been answered in the past. Try this article:

How to pivot rows to columns in Snowflake