view: dt_track_types_by_store {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_TRACK_TYPES_BY_STORE ;;

#   derived_table: {
#     sql: SELECT dms_master_master_id, LISTAGG(DISTINCT t.track_type,', ') WITHIN GROUP(ORDER BY t.track_type ASC) AS track_types FROM orchard_app_reporting_v2.reportsdd_direct_delivery.encoding_queue_detail eqd
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track t ON t.upc=eqd.upc
# GROUP BY dms_master_master_id
#       ;;
#   }


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

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

}