view: facts_prod_dim_track {
  sql_table_name: facts.prod.dim_track ;;

  dimension: track_id {
    type: number
    sql: ${TABLE}.trackid ;;
    primary_key: yes
  }

  dimension: track_unique_id {
    label: "TUID"
    description: "Track Unique Identifier (TUID)"
    type: number
    sql: ${TABLE}.track_unique_id ;;
  }

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

  dimension: isrc_ex_da {
    label: "ISRC (Exclude DA)"
    description: "Excludes ISRCs used for album-level sales"
    type:  string
    sql: IFF(${TABLE}.isrc LIKE '%_ISRC', '', ${TABLE}.isrc) ;;
  }

  dimension: track_name {
    type: string
    sql: ${TABLE}.trackname ;;
  }

  dimension: track_name_ex_da {
    label: "Track Name (Exclude DA)"
    description: "Excludes Track Names used for album-level sales"
    type:  string
    sql: IFF(${TABLE}.isrc LIKE '%_ISRC', '', ${TABLE}.trackname) ;;
  }

  dimension: duration {
    type: number
    sql: ${TABLE}.duration ;;
    hidden: yes
  }

  dimension: upc {
    type: string
    sql: ${TABLE}.upc ;;
    hidden: yes
  }
}