# View: performer_primary_snowflake

**View Name:** performer_primary_snowflake
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Ows_Track_Ows_Track, Prod_Ows_Track_Ows_Track.Performer, Prod_Ows_Track_Ows_Track.Performer_Role`
**File Path:** `performer_primary_snowflake.view.lkml`

## Overview

- **File Size:** 1427 bytes
- **Lines of Code:** 45
- **Dimensions:** 2
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- This view pulls only the first five primary performers alphabetically

## Dimensions

| Name | Type |
|------|------|
| `unique_track_id` | number |
| `performer_info` | string |

## Measures

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

## Derived Table

```sql
sql: select a.unique_track_id
        , listagg(a.performer_type || '|' || a.birth_name || '|' || a.performer_role, '|') as performer_info
from
    (select p.unique_track_id
        , p.performer_type
        , p.birth_name
        , pr.performer_role
        , row_number() over(partition by p.unique_track_id order by p.birth_name) as artist_count
      from orchard_app_reporting_v2.prod_ows_track_ows_track.performer p
      left join orchard_app_reporting_v2.prod_ows_track_ows_track.performer_role pr on p.performer_role_id=pr.performer_role_id
      where p.performer_type='primary'
      order by p.unique_track_id) a
where artist_count<=5
group by 1
 ;;
```