view: orch_app_ar_track_publisher {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.track_publisher ;;

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

  dimension: unique_track_id {
    type: number
    sql: ${TABLE}.unique_track_id ;;
  }

  dimension: publisher_name {
    type: string
    sql: ${TABLE}.publisher_name ;;
  }

  dimension: ownership {
    type: number
    sql: ${TABLE}.ownership ;;
  }

#   dimension: cd {
#     type: number
#     sql: ${TABLE}.cd ;;
#   }
#
#   dimension: track_id {
#     type: number
#     sql: ${TABLE}.track_id ;;
#   }
#
#   dimension: upc {
#     type: number
#     sql: ${TABLE}.upc ;;
#   }
#
#   measure: publishers {
#     type: string
#     sql: LISTAGG(DISTINCT publisher_name, ', ') WITHIN GROUP (ORDER BY publisher_name) ;;
#     view_label: "Track"
#     label: "Publisher(s)"
#   }
}