# View: release_artist_snowflake

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

## Overview

- **File Size:** 3039 bytes
- **Lines of Code:** 135
- **Dimensions:** 14
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: release_artist_id {
- type: number
- sql: ${TABLE}.RELEASE_ARTIST_ID ;;

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `role` | string |
| `release_id` | number |
| `release_artist_name_performer` | string |
| `release_artist_name_featuring` | string |
| `release_artist_name_remixer` | string |
| `release_artist_name_composer` | string |
| `release_artist_name_orchestra` | string |
| `release_artist_name_ensemble` | string |
| `release_artist_name_conductor` | string |
| `release_artist_name_arranger` | string |
| `release_artist_name_other` | string |
| `release_artist_name_director` | string |
| `release_artist_name_producer` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `count_distinct_release_artist_performer` | count_distinct |

## Derived Table

```sql
sql:
      SELECT ra.upc, ra.role, ra.release_id, listagg(distinct ra.artist_name, ', ') as artist_name
      from orchard_app_reporting_v2.art_relations_prod_art_relations.release_artist ra
      group by 1, 2, 3;;
```