# View: release_artist_snowflake_all

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

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `artist_name_all` | string |

## Measures

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

## Derived Table

```sql
sql: select release_id
        , listagg(distinct artist_name , ', ') within group (order by artist_name desc) as artist_name_all
from orchard_app_reporting_v2.art_relations_prod_art_relations.release_artist
group by 1
 ;;
```