view: int_dbt_prod_apple_spatial_audio_deliveries {
  sql_table_name: intelligence.dbt_prod.apple_spatial_audio_delivery_history ;;

  dimension: upc {
    description: "The unique identifier for a product (i.e Unique Product Code)."
    type: number
    value_format: "#"
    sql: ${TABLE}.upc ;;
  }

  dimension: artist_name {
    description: "The name of the aritst."
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: release_name {
    description: "The name of the release."
    type: string
    sql: ${TABLE}.release_name ;;
  }

  dimension: sale_start_date {
    description: "The date that a product goes live on streaming services."
    type: date
    sql: ${TABLE}.sale_start_date ;;
  }

  dimension: label_id {
    description: "The unique identifier for a label."
    type: number
    sql: ${TABLE}.vendor_id ;;
  }

  dimension: label_name {
    description: "The labels name."
    type: string
    sql: ${TABLE}.vendor_name ;;
  }

  dimension: store_id {
    description: "The unique identifier for a store."
    type: number
    sql: ${TABLE}.customer_master_master_id ;;
  }

  dimension: store_name {
    description: "The name of the store."
    type: string
    sql: ${TABLE}.customer_name ;;
  }

  dimension: first_delivered_on {
    description: "The name of the store."
    type: date
    sql: ${TABLE}.first_delivered_on ;;
  }

  dimension: track_name{
    description: "The name of the track."
    type: string
    sql: ${TABLE}.track_name ;;
  }

  dimension: isrc {
    description: "The tracks international sound recording code."
    type: string
    sql: ${TABLE}.isrc ;;
  }

}