view: int_dbt_prod_westcott_daily_schedules {
  sql_table_name: intelligence.dbt_prod.westcott_daily_schedules ;;

  dimension_group: download_activity_date {
    view_label: "Date"
    label: "Activity"
    type: time
    description: "Date of consumption"
    sql: ${TABLE}.download_activity_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }


  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: store {
    view_label: "Store"
    label: "Store Name"
    type: string
    sql: ${TABLE}.storename ;;
    description: "Store"
  }

  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: transaction_country {
    view_label: "Transaction Country"
    label: "Country name"
    type: string
    sql: ${TABLE}.transaction_country ;;
    description: "Name of country of consumption"
  }

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

  dimension_group: release_date {
    view_label: "Date"
    label: "Release"
    type: time
    description: "Date of original release"
    sql: ${TABLE}.release_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  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 ;;
  }

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

  dimension: transaction_detail {
    type: string
    view_label: "Transaction Type"
    label: "Transaction Description"
    full_suggestions: no
    sql: ${TABLE}.transactiontypedesc ;;
    description: "Detail of transaction type"
  }

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

  dimension: playlist_id {
    type: string
    view_label: "Playlist"
    label: "Playlist ID"
    full_suggestions: no
    sql: ${TABLE}.playlistid ;;
    description: "Unique playlist id for the stream (Null if its not a playlist stream)"
  }

  dimension: playlist_name {
    type: string
    view_label: "Playlist"
    label: "Playlist Name"
    full_suggestions: no
    sql: ${TABLE}.playlistname ;;
    description: "Playlist Name for the stream (Null if its not a playlist stream)"
  }

  dimension: playlist_type_name {
    type: string
    view_label: "Playlist"
    label: "Playlist Type"
    full_suggestions: no
    sql: ${TABLE}.playlisttypename ;;
    description: "Type of playlist for the stream (Null if its not a playlist stream)"
  }

  dimension: playlist_uri {
    type: string
    view_label: "Playlist"
    label: "Playlist URI"
    full_suggestions: no
    sql: ${TABLE}.playlisturi ;;
    description: "Playlist URI for the stream (Null if its not a playlist stream)"
  }

  dimension: container_type_name {
    type: string
    view_label: "Playlist"
    label: "Container Type"
    full_suggestions: no
    sql: ${TABLE}.containertypename ;;
    description: "Container Name for Apple Music streams"
  }

  dimension: age_group {
    type: string
    view_label: "User"
    label: "Age Group"
    full_suggestions: no
    sql: ${TABLE}.age_group ;;
    description: "Age group of the user"
  }

  dimension: gender {
    type: string
    view_label: "User"
    label: "Gender"
    full_suggestions: no
    sql: ${TABLE}.gender ;;
    description: "gender of the user"
  }

  dimension: user_country {
    type: string
    view_label: "User"
    label: "User Country"
    full_suggestions: no
    sql: ${TABLE}.countrycode ;;
    description: "Country of the user"
  }

  dimension: user_id {
    type: string
    view_label: "User"
    label: "User ID"
    full_suggestions: no
    sql: ${TABLE}.userid ;;
    description: "Unique user ID"
  }

  dimension: region_code {
    type: string
    view_label: "User"
    label: "User Region"
    full_suggestions: no
    sql: ${TABLE}.regioncode ;;
    description: "Region code for the user"
  }

  dimension: region_name {
    type: string
    view_label: "Transaction Country"
    label: "Region Name"
    full_suggestions: no
    sql: ${TABLE}.orchard_region_name ;;
    description: "Region of transaction"
  }

  dimension: regioncode {
    type: string
    view_label: "Transaction Country"
    label: "Region Code"
    full_suggestions: no
    sql: ${TABLE}.region_code ;;
    description: "Region of transaction"
  }

  dimension: orchard_region_code {
    type: string
    view_label: "Transaction Country"
    label: "Orchard Region Code"
    full_suggestions: no
    sql: ${TABLE}.orchard_region_code ;;
    description: "Region of transaction"
  }

  dimension: subscription_type_name {
    type: string
    view_label: "Subscription"
    label: "Subscription Type"
    full_suggestions: no
    sql: ${TABLE}.subscriptiontypename ;;
    description: "Type of user susbcription"
  }

  dimension: subscription_pay_tier_name {
    type: string
    view_label: "Subscription"
    label: "Subscription Pay Tier"
    full_suggestions: no
    sql: ${TABLE}.subscriptionpaytiername ;;
    description: "Type of user susbcription (ad, paid, trial)"
  }

  dimension: source_type_name {
    type: string
    view_label: "Source of Stream"
    label: "Source Name (original Values)"
    full_suggestions: no
    sql: ${TABLE}.sourcetypename ;;
    description: "Source of Stream"
  }

  dimension: source_name {
    type: string
    view_label: "Source of Stream"
    label: "Source Name"
    full_suggestions: no
    sql: ${TABLE}.source_name ;;
    description: "Source of Stream (Grouped values)"
  }
}