view: int_dbt_prod_westcott_schedules_cumulative_units {
sql_table_name: intelligence.dbt_prod.westcott_schedules_cumulative_units ;;

  dimension_group: curr_date {
    view_label: "Date"
    label: "Current"
    type: time
    description: "Date of consumption"
    sql: ${TABLE}.curr_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date
      ]
  }


  dimension: label_id {
    type: number
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.labelid ;;
    description: "Label ID"
  }

  dimension: upc {
    type: number
    view_label: "Release"
    label: "UPC"
    value_format: "#"
    sql: ${TABLE}.upc ;;
    description: "Unique Product Code"
  }

  dimension: isrc {
    view_label: "Track"
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc ;;
    description: "ISRC"
  }

  dimension: imprint_name {
    view_label: "Release"
    label: "Imprint Name"
    type: number
    sql: ${TABLE}.imprint_name ;;
    description: "Imprint associated with the release"
  }

  dimension: subaccount_name {
    view_label: "Subaccount"
    label: "Subaccount Name"
    type: string
    sql: ${TABLE}.subaccountname ;;
    description: "Subaccount associated with the release"
  }

  dimension: label_name {
    view_label: "Label"
    label: "Label Name"
    type: string
    sql: ${TABLE}.labelname ;;
    description: "Label Name associated with the release"
  }

  dimension: release_name {
    view_label: "Release"
    type: string
    label: "Release Name"
    description: "Name of the release"
    sql: ${TABLE}.release_name;;
  }

  dimension: vendor_catalog_number {
    view_label: "Release"
    type: string
    label: "Catalog Number"
    description: "Unique identifier for each release in system"
    sql: ${TABLE}.vendor_catalog_number;;
  }

  dimension: track_name {
    type: string
    view_label: "Track"
    label: "Track Name"
    description: "Track Name"
    sql: ${TABLE}.trackname ;;
  }

  dimension: artist_name {
    type: string
    view_label: "Artist"
    label: "Artist Name"
    description: "Primary artist associated with the release"
    sql: ${TABLE}.artistname ;;
  }

  measure: units {
    type: sum
    view_label: "Consumption"
    label: "Units"
    sql: ${TABLE}.units ;;
    description: "Total streams and downloads"
  }

}