Snowflake date and time dimension

Published on January 28, 2019
Updated on August 3, 2023

Here is a simple SQL script that will generate a date dimension in Snowflake. We are using the built-in GENERATOR and SEQ function. Start date for the dimension is 2017-01-01.

If you need a little extra and want to include a global holiday calendar in your date dimension you will be glad to hear that we have made a Date Dimension with Global Holiday Calendar dataset available on the marketplace If you want to find out more about our dataset go to our blog post where we explain it in more depth