0

Need to create U.S holiday Calendar in Snowflake to use for Date Dimension

Guru
  • 11
  • 3
  • I need to US Holiday calendar to populate data into Data Dimension table in Snowflake. Please let me know how to get the US calendar list and do the needful... – Guru Jun 14 '22 at 12:17
  • You need to provide more information then this. Holidays can be different for different year. You can generate a year calendar using synthetic rows with something like TABLE(GENERATOR(ROWCOUNT => 365) and then identify which days are holiday in that. – Pankaj Jun 14 '22 at 12:34
  • 1
    Hi , either you will have to identify year by year the holidays and store it in a table or you can use the following who have the holiday calendar , https://www.snowflake.com/datasets/sonra-date-dimension-with-global-holiday-calendar/ – Himanshu Kandpal Jun 14 '22 at 12:51
  • Correct , i will be creating the holiday list in a table. Now the issue is where can i get the entire holiday list for couple of years ?? – Guru Jun 14 '22 at 12:58
  • Similar question here - https://stackoverflow.com/questions/58617459/easter-good-friday-for-sowflake-date-dim/58621818#58621818 – Pankaj Jun 14 '22 at 12:59
  • every holiday follows a set of rules to calculate what day it falls on. You can easily do this yourself, example: https://stackoverflow.com/questions/18326446/how-to-calculate-holidays-for-the-usa – Sorceri Jun 14 '22 at 19:57

0 Answers0