view: dt_track_writers {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_TRACK_WRITERS ;;
#   derived_table: {
#     sql:
# SELECT unique_track_id AS tuid,
# LISTAGG(DISTINCT writer_name, ', ') WITHIN GROUP (ORDER BY writer_name) AS track_writers
# FROM orchard_app_reporting_v2.art_relations_prod_art_relations.track_writer
# WHERE LENGTH(TRIM(writer_name)) != 0
# GROUP BY 1 ;;
#   }

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

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