view: closed_caption_reasons_snowflake {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.closed_caption_reasons ;;


  measure: count {
    type: count
    drill_fields: [detail*]
  }
  dimension: reason_code {
    label: "Closed Caption Reason Code"
    type: string
    sql: ${TABLE}.REASON_CODE ;;
  }

  dimension: id {
    hidden: yes
    type: number
    sql: ${TABLE}.ID ;;
  }

  dimension: reason_description {
    label: "Closed Caption Reason Description"
    type: string
    sql: ${TABLE}.REASON_DESCRIPTION ;;
  }

  set: detail {
    fields: [
      reason_code,
      id,
      reason_description
    ]
  }
}