# View: dt_track_publishers

**View Name:** dt_track_publishers
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Track_Publisher, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `dt_track_publishers.view.lkml`

## Overview

- **File Size:** 514 bytes
- **Lines of Code:** 24
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `tuid` | number |
| `publishers` | string |

## Derived Table

```sql
sql:
SELECT unique_track_id AS tuid,
LISTAGG(DISTINCT publisher_name, ', ') WITHIN GROUP (ORDER BY publisher_name) AS publishers
FROM orchard_app_reporting_v2.art_relations_prod_art_relations.track_publisher
GROUP BY 1 ;;
```