# View: dt_store_artist_id_name

**View Name:** dt_store_artist_id_name
**Table Source:** `Derived from: Prod.Label_Participant`
**File Path:** `dt_store_artist_id_name.view.lkml`

## Overview

- **File Size:** 923 bytes
- **Lines of Code:** 46
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- Add fields for the derived table

## Dimensions

| Name | Type |
|------|------|
| `release_artist` | string |
| `uuid` | string |
| `store_name` | string |
| `store_artist_id` | string |

## Derived Table

```sql
sql: SELECT
    lp.name AS release_artist,
    lp.uuid,
    'Apple' AS store_name,
    lp.apple_music_id AS store_artist_id
    FROM
    facts.prod.label_participant lp

    UNION ALL

    SELECT
    lp.name AS release_artist,
    lp.uuid,
    'Spotify' AS store_name,
    lp.spotify_id AS store_artist_id
    FROM
    facts.prod.label_participant lp;;
```