view: dt_track_samples {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_TRACK_SAMPLES ;;
#   derived_table: {
#     sql:
# SELECT unique_track_id AS tuid,
# LISTAGG(DISTINCT track_name, ', ') WITHIN GROUP (ORDER BY track_name) AS samples
# FROM orchard_app_reporting_v2.prod_ows_track_ows_track.track_sample
# GROUP BY 1 ;;
#   }

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

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

}