# View: track_publisher_snowflake

**View Name:** track_publisher_snowflake
**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:** `track_publisher_snowflake.view.lkml`

## Overview

- **File Size:** 1089 bytes
- **Lines of Code:** 62
- **Dimensions:** 6
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `cd` | number |
| `upc` | number |
| `ownership` | number |
| `publisher_name` | string |
| `unique_track_id` | number |
| `track_id` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql:select tp.cd, tp.upc, tp.ownership, tp.unique_track_id, tp.track_id, listagg(distinct tp.publisher_name, ', ') as publisher_name
    from orchard_app_reporting_v2.art_relations_prod_art_relations.track_publisher tp
    group by 1, 2, 3, 4, 5;;
```