view: facts_prod_dim_track_clean_mv {
  sql_table_name: facts.prod.dim_track_clean_mv ;;

  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: track_name {
    type: string
    sql: ${TABLE}.trackname ;;
  }


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

  dimension: labelid {
    type: number
    sql: ${TABLE}.labelid ;;
    hidden: no
  }

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

  dimension: third_party_publisher {
    type: string
    sql: ${TABLE}.third_party_publisher ;;
    hidden: no
  }
}