view: dt_track_performers {
  derived_table: {
    sql:
      SELECT unique_track_id AS tuid,
      LISTAGG(DISTINCT birth_name, ', ') WITHIN GROUP (ORDER BY birth_name) AS performers
      FROM orchard_app_reporting_v2.ows_track.performer
      GROUP BY 1 ;;
  }

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

  dimension: performers {
    type: string
    sql: ${TABLE}.performers ;;
    view_label: "Track"
    label: "Performer(s)"
  }
}