11 September 2020

The type of column ‘xxx’ conflicts with the type of other columns in the UNPIVOT list.

UNPIVOT is a SQL standard function that allows users to transform columns into rows, and Snowflake also supports it. Please see below example on how to use it: You can see that the result turned the scores that were in each column of a row into seperate rows that still associated with original student ID. This query works well for the columns defined in UNPIVOT […]

23 August 2020

Loading Data into Snowflake

Welcome to my first Snowflake blog post. Since I just started as a Cloud Data Warehouse Engineer 2 weeks ago, Snowflake is also very new to me. I have spent sometime played around with Snowflake interface and learn how to load data from local file system into Snowflake and then query from Snowflake Web UI. I have noticed that though loading data is straight forward, […]

22 August 2020

Snowflake Adventure!

If you have been following me on my Cloudera Blog, you probably know me well enough. I worked at Cloudera as a Support Engineer for the last 5.5 years. I have decided to move on and started at Snowflake as a Cloud Data Warehouse Engineer (Cloud Support Engineer) since last week. Don’t get me wrong. I really enjoyed working at Cloudera and I did feel […]