# View: dt_split_release_artists

**View Name:** dt_split_release_artists
**Table Source:** `Derived from: Prod.Global_Participant_Represents_Label_Participant, Prod.Label_Participant, Prod.Label_Participant_Participated_In_Orchard_Product, Prod.Orchard_Product, Prod.Release_Artist`
**File Path:** `dt_split_release_artists.view.lkml`

## Overview

- **File Size:** 5980 bytes
- **Lines of Code:** 140
- **Dimensions:** 7
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: SELECT sub_table.*, gp_r_lp.global_participant_id, gp_r_lp.label_participant_id
- FROM facts.prod.release_artist ra

## Dimensions

| Name | Type |
|------|------|
| `product_id` | number |
| `label_participant_uuid` | string |
| `role` | string |
| `name` | string |
| `product_name` | string |
| `global_participant_id` | string |
| `label_participant_id` | number |

## Measures

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

## Derived Table

```sql
#   sql: SELECT sub_table.*, gp_r_lp.global_participant_id, gp_r_lp.label_participant_id
  #   FROM facts.prod.release_artist ra
  #   INNER JOIN facts.prod.ORCHARD_PRODUCT AS dr ON dr.id = ra.product_id
  #   LEFT JOIN (
  #   SELECT product_id, label_participant_uuid, rel.participated_as as role, lower(lp.name) as name, lp.normalized_name
  #   FROM facts.prod.label_participant_participated_in_orchard_product rel
  #   Inner JOIN facts.prod.label_participant lp ON rel.label_participant_uuid = lp.uuid
  #   ) sub_table
  #   ON ra.product_id = sub_table.product_id and ra.role = sub_table.role and lower(regexp_replace(trim(sub_table.normalized_name), '[ ]+', '')) = lower(trim(regexp_replace(ra.name, '[ ]+', ''), ' \t\n\u000B\f\r\u001C\u001D\u001E\u001F\u1680\u2000\u2001\u2002\u2003\u2004\u2005\u2006\u2008\u2009\u200A\u205F\u3000\u2028\u2029'))
  #   INNER JOIN facts.prod.global_participant_represents_label_participant gp_r_lp  ON gp_r_lp.label_participant_uuid = sub_table.label_participant_uuid ;;
  #
```