view: label_review_analytics_all_stores {
  sql_table_name: INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_ALL_STORES ;;

  dimension: catalog {
    view_label: "Release"
    label: "Catalog Type"
    type: string
    sql: ${TABLE}.CATALOG ;;
  }
  dimension_group: download_activity_month {
    type: time
    view_label: "Date"
    label: "Activity Date"
    timeframes: [month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.DOWNLOAD_ACTIVITY_MONTH ;;
  }
  dimension: label_id {
    view_label: "Label"
    label: "Label ID"
    type: number
    sql: ${TABLE}.LABEL_ID ;;
  }
  dimension: source_of_stream_buckets {
    view_label: "Source of Stream"
    label: "Active/Passive/Collection"
    type: string
    sql: ${TABLE}.SOURCE_OF_STREAM_BUCKETS ;;
  }
  dimension: sub_store {
    view_label: "Store"
    label: "Store"
    type: string
    sql: ${TABLE}.SUB_STORE ;;
  }
  dimension: subscription_type {
    view_label: "Subscription Type"
    label: "Subscription Type"
    type: string
    sql: ${TABLE}.SUBSCRIPTION_TYPE ;;
  }
  measure: streams {
    view_label: "Streams"
    label: "Streams"
    type: sum
    sql: ${TABLE}.STREAMS ;;
  }
}