Date Dim

view: date_dim {
  sql_table_name: public.date_dim ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  dimension: calendar_month_name {
    sql: ${TABLE}.calendar_month_name ;;
  }

  dimension: calendar_month_name_abbrev {
    sql: ${TABLE}.calendar_month_name_abbrev ;;
  }

  dimension: calendar_month_number {
    type: int
    sql: ${TABLE}.calendar_month_number ;;
  }

  dimension: calendar_quarter {
    sql: ${TABLE}.calendar_quarter ;;
  }

  dimension: calendar_quarter_number {
    type: int
    sql: ${TABLE}.calendar_quarter_number ;;
  }

  dimension: calendar_week {
    sql: ${TABLE}.calendar_week ;;
  }

  dimension: calendar_week_number {
    type: int
    sql: ${TABLE}.calendar_week_number ;;
  }

  dimension: calendar_year {
    sql: ${TABLE}.calendar_year ;;
  }

  dimension: calendar_year_month {
    sql: ${TABLE}.calendar_year_month ;;
  }

  dimension: calendar_year_month_number {
    type: int
    sql: ${TABLE}.calendar_year_month_number ;;
  }

  dimension: calendar_year_number {
    type: int
    sql: ${TABLE}.calendar_year_number ;;
  }

  dimension: calendar_year_quarter {
    sql: ${TABLE}.calendar_year_quarter ;;
  }

  dimension: calendar_year_quarter_number {
    type: int
    sql: ${TABLE}.calendar_year_quarter_number ;;
  }

  dimension: date {
    sql: ${TABLE}.date ;;
  }

  dimension: day_abbrev {
    sql: ${TABLE}.day_abbrev ;;
  }

  dimension: day_name {
    sql: ${TABLE}.day_name ;;
  }

  dimension: day_num_in_month {
    type: int
    sql: ${TABLE}.day_num_in_month ;;
  }

  dimension: day_of_week {
    type: int
    sql: ${TABLE}.day_of_week ;;
  }

  dimension: full_date_description {
    sql: ${TABLE}.full_date_description ;;
  }

  dimension: holiday_indicator {
    sql: ${TABLE}.holiday_indicator ;;
  }

  dimension: major_event {
    sql: ${TABLE}.major_event ;;
  }

  dimension: weekday_indicator {
    sql: ${TABLE}.weekday_indicator ;;
  }

  dimension_group: sql_date_stamp {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.sql_date_stamp ;;
  }

  measure: count {
    type: count
    drill_fields: [id, day_name, calendar_month_name]
  }
}

- view: date_dim
  sql_table_name: public.date_dim
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: calendar_month_name
    sql: ${TABLE}.calendar_month_name
  - dimension: calendar_month_name_abbrev
    sql: ${TABLE}.calendar_month_name_abbrev
  - dimension: calendar_month_number
    type: int
    sql: ${TABLE}.calendar_month_number
  - dimension: calendar_quarter
    sql: ${TABLE}.calendar_quarter
  - dimension: calendar_quarter_number
    type: int
    sql: ${TABLE}.calendar_quarter_number
  - dimension: calendar_week
    sql: ${TABLE}.calendar_week
  - dimension: calendar_week_number
    type: int
    sql: ${TABLE}.calendar_week_number
  - dimension: calendar_year
    sql: ${TABLE}.calendar_year
  - dimension: calendar_year_month
    sql: ${TABLE}.calendar_year_month
  - dimension: calendar_year_month_number
    type: int
    sql: ${TABLE}.calendar_year_month_number
  - dimension: calendar_year_number
    type: int
    sql: ${TABLE}.calendar_year_number
  - dimension: calendar_year_quarter
    sql: ${TABLE}.calendar_year_quarter
  - dimension: calendar_year_quarter_number
    type: int
    sql: ${TABLE}.calendar_year_quarter_number
  - dimension: date
    sql: ${TABLE}.date
  - dimension: day_abbrev
    sql: ${TABLE}.day_abbrev
  - dimension: day_name
    sql: ${TABLE}.day_name
  - dimension: day_num_in_month
    type: int
    sql: ${TABLE}.day_num_in_month
  - dimension: day_of_week
    type: int
    sql: ${TABLE}.day_of_week
  - dimension: full_date_description
    sql: ${TABLE}.full_date_description
  - dimension: holiday_indicator
    sql: ${TABLE}.holiday_indicator
  - dimension: major_event
    sql: ${TABLE}.major_event
  - dimension: weekday_indicator
    sql: ${TABLE}.weekday_indicator
  - dimension_group: sql_date_stamp
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.sql_date_stamp
  - measure: count
    type: count
    drill_fields:
    - id
    - day_name
    - calendar_month_name