Date dimension for Snowflake

Analysis area Date dimension for Snowflake within Prod OMNIA Partners EDW at 25-Mar-2025 12:12:02

Table Name

Date dimension for Snowflake

Description

This is the dim table dim_date.

Purpose

Concept

Grain

Table Definition

Display NameColumn NameComments
Calendar DateCALENDAR_DATEThe calendar date for this row.
Cal Day In WeekCAL_DAY_IN_WEEKThe day in the week. Format DDD. Example: mon, tue, wed.
Cal Day In Week NoCAL_DAY_IN_WEEK_NOThe day number in the week. 1-7 where Sunday is day 1.
Cal Day In MonthCAL_DAY_IN_MONTHThe day in the month 1-31.
Cal Day In YearCAL_DAY_IN_YEARThe day in the year 1-366.
Cal Week In YearCAL_WEEK_IN_YEARThe week in the year 0-53.
Cal Month NoCAL_MONTH_NOThe calendar month number 1-12.
Cal MonthCAL_MONTHThe calendar month representation. Format YYYYMM. Example: 200206.
Cal Month NameCAL_MONTH_NAMEThe calendar month name. Format MON. Examples: jan, feb, mar.
Cal Quarter NoCAL_QUARTER_NOThe calendar quarter number 1-4.
Cal QuarterCAL_QUARTERThe calendar quarter representation. Format YYYYQQ. Example 200204.
Cal YearCAL_YEARThe calendar year. Format YYYY
Financial DateFINANCIAL_DATEThe financial date. Same as calendar date.
Fin Day In WeekFIN_DAY_IN_WEEKThe financial day in the week. Format DDD. Example: mon,tue,wed.
Fin Day In Week NoFIN_DAY_IN_WEEK_NODay number in the current financial week.
Fin Day In MonthFIN_DAY_IN_MONTHFinancial day in the month. Normally the same as calendar day in the month, unless the financial period starts mid calendar month.
Fin Day In YearFIN_DAY_IN_YEARFinancial day in the year. Number of days since the start of the financial year.
Fin Week In MonthFIN_WEEK_IN_MONTHFinancial week in the financial month.
Fin Week In YearFIN_WEEK_IN_YEARFinancial week in the financial year. Number of weeks since the start of the financial year
Fin Month NoFIN_MONTH_NOFinancial month number. Format MM. Examples: 1,2,3.
Fin MonthFIN_MONTHFinancial month representation. Fromat YYYYMM. Examples: 200101, 200102.
Fin Month NameFIN_MONTH_NAMEFinancial month. Format MON. Examples: jan, feb, mar.
Fin PeriodFIN_PERIODFinancial period. Format (YYYY-MM) MON-YYYY. Example: (2001-02) Feb-2002.
Fin Quarter NoFIN_QUARTER_NOFinancial quarter number (1-4).
Fin QuarterFIN_QUARTERFinancial quarter representation. Format YYYYQQ. Example: 198901.
Fin YearFIN_YEARFinancial year. Format YYYY.
Current Cal DayCURRENT_CAL_DAYFlag to indicate the current day. Normally set to the last day information was updated in the data warehouse.
Current Cal WeekCURRENT_CAL_WEEKFlag to indicate the current week. Set as per current_cal_day.
Current Cal MonthCURRENT_CAL_MONTHFlag to indicate the current month. Set as per current_cal_day.
Current Cal YearCURRENT_CAL_YEARFlag to indicate the current year. Set as per current_cal_day.
Current Cal MtdCURRENT_CAL_MTDFlag to indicate days in the current month to date. Set as per current_cal_day.
Current Cal YtdCURRENT_CAL_YTDFlag to indicate days in the current year to date. Set as per current_cal_day.
Moving Cal YearMOVING_CAL_YEARFlag to indicate days that constitute a full year counting back from the current day. Set as per current_cal_day.
Current Fin DayCURRENT_FIN_DAYFlag to indicate the current financial day. Normally set to the last financial day information was updated in the data warehouse.
Current Fin WeekCURRENT_FIN_WEEKFlag to indicate the current financial week. Set as per current_fin_day.
Current Fin MonthCURRENT_FIN_MONTHFlag to indicate the current financial month. Set as per current_fin_day.
Current Fin QuarterCURRENT_FIN_QUARTERFlag to indicate the current financial quarter. Set as per current_fin_day.
Current Fin YearCURRENT_FIN_YEARFlag to indicate the current financial year. Set as per current_fin_day.
Current Fin MtdCURRENT_FIN_MTDFlag to indicate days in the current financial month to date. Set as per current_fin_day.
Current Fin YtdCURRENT_FIN_YTDFlag to indicate days in the current financial year to date. Set as per current_fin_day.
Moving Fin QuarterMOVING_FIN_QUARTERFlag to indicate days that constitute a quarter counting back from the current financial day. Set as per current_fin_day.
Moving Fin YearMOVING_FIN_YEARFlag to indicate days that constitute a financial year counting back from the current financial day. Set as per current_fin_day.
Week Day FlagWEEK_DAY_FLAGFlag to indicate if a week day Y=week day N=week end.
Week End FlagWEEK_END_FLAGFlag to indicate a week end day. Y=week end, N=week day.
Holiday FlagHOLIDAY_FLAGFlag to indicate that the day in question is a holiday. Y=holiday, N=normal.
Holiday DescHOLIDAY_DESCDescription of the holiday when a holiday.
Trading Day FlagTRADING_DAY_FLAGFlag to indicate a trading day. Y=trading, N=non trading.
Trading Days In MthTRADING_DAYS_IN_MTHNumber of trading days in this calendar month.
Trading Days So FarTRADING_DAYS_SO_FARNumber of trading days in the month so far.

Column Documentation

No documentation found

Fact Tables

The table Date dimension for Snowflake links to the following Fact Tables.
No Fact Tables found for this object.

Examples

Usage

Return to Top