In most data warehouse implementations, a date dimension is created to standardize dates and make time bucketing easier. In this quick example I will discuss how to create a simple query that can generate a table for a Date Dimension. Creating the Ranges & Session Variables ALTER SESSION SET WEEK_START = 0; SET (START_DATE,END_DATE) = … Continue reading A quick Date Dimension with Snowflake
-
Subscribe
Subscribed
Have a WordPress.com account? Log in now.
