view: period_snowflake {
    sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.period ;;

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  dimension: month {
    type: number
    sql: ${TABLE}.MONTH ;;
  }

  dimension: year {
    type: number
    sql: ${TABLE}.YEAR ;;
  }

  dimension: period_id {
    primary_key: yes
    type: number
    sql: ${TABLE}.PERIOD_ID ;;
  }

  dimension: quarter {
    type: number
    sql: ${TABLE}.QUARTER ;;
  }

  dimension: status {
    type: string
    sql: ${TABLE}.STATUS ;;
  }

  dimension_group: period_as_date {
    label: "Period Date"
    type: time
    timeframes: [
      date,
      year,
      month,
      month_num,
      quarter,
      month_name,
      quarter_of_year,
      fiscal_year,
      fiscal_quarter,
      fiscal_month_num,
      fiscal_quarter_of_year]
    sql: DATE_FROM_PARTS(${TABLE}.year, ${TABLE}.month, '01')  ;;
  }

  set: detail {
    fields: [
      month,
      year,
      period_id,
      quarter,
      status
    ]

  }

}