Timestamp Precision Rounding

Currently in Snowflake, it supports using the precision format of FF<N>, where N is a number between 0 to 9, to display precision part of the timestamp value. To demonstrate how it works, please see below examples: By default the output returns only 3 digits, which is up to milliseconds, is because the session level […]

Continue Reading

GROUP BY CUBE Has Limit of 7 Elements

Currently if you use GROUP BY CUBE clause in Snowflake, it has the limitation of supporting only 7 elements, or the equivalent of 128 grouping sets. This is documented in below Snowflake’s official documentation: GROUP BY CUBE Usage NotesSnowflake allows up to 7 elements (equivalent to 128 grouping sets) in each cube. This same limitation […]

Continue Reading

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. […]

Continue Reading

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. […]

Continue Reading