# View: track_credit_snowflake

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

## Overview

- **File Size:** 1591 bytes
- **Lines of Code:** 85
- **Dimensions:** 11
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `role` | string |
| `crew_or_cast` | string |
| `track_id` | number |
| `artist_name_director` | string |
| `artist_name_producer` | string |
| `artist_name_editor` | string |
| `artist_name_other` | string |
| `amg_id` | string |
| `id` | number |
| `url` | string |
| `billing` | string |

## Measures

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

## Derived Table

```sql
sql:select role, crew_or_cast, track_id, amg_id, id, url, billing, listagg(distinct artist_first_name || ' ' || artist_last_name, ', ') as artist_name
        from orchard_app_reporting_v2.art_relations_prod_art_relations.track_credit
        group by 1, 2, 3, 4, 5, 6, 7;;
```