view: dt_mising_upc_track_mapping {
  derived_table: { sql:
    select
    upc,
    isrc,
    track_name
     from
 ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.TRACK
   qualify row_number() over (partition by isrc order by upc)=1;;
  }

  dimension: upc {
    label: "UPC"
    hidden: yes
    type: number
    sql: ${TABLE}.upc ;;
  }

  dimension: isrc {
    label: "ISRC"
    hidden: yes
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: track_name {
    label: "Track name"
    hidden: yes
    type: string
    sql: ${TABLE}.track_name ;;
  }
}