view: dt_track_performers {
  sql_table_name: INTELLIGENCE.DBT_PROD.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.prod_ows_track_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)"
  }
}