# View: dt_abacus_track_artists

**View Name:** dt_abacus_track_artists
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Project, Art_Relations_Prod_Art_Relations.Releases, Art_Relations_Prod_Art_Relations.Track, Prod.Label_Participant, Prod.Label_Participant_Participated_In_Orchard_Product + 3 more`
**File Path:** `views/dt_abacus_track_artists.view.lkml`

## Overview

- **File Size:** 1962 bytes
- **Lines of Code:** 62
- **Dimensions:** 8
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `label_id` | number |
| `upc` | number |
| `track_id` | string |
| `isrc` | string |
| `track_name` | string |
| `cd` | number |
| `tuid` | string |
| `track_artist_list` | string |

## SQL Comments

- products
- tracks

## Derived Table

```sql
sql:
        select v.vendor_id label_id,r.upc,t.id as tuid, t.track_id, t.isrc,t.track_name,t.cd,
            listagg(distinct lp2.name,', ') within group (order by lp2.name) track_artist_list
        from royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v
        join orchard_app_reporting_v2.art_relations_prod_art_relations.project p on p.vendor_id=v.vendor_id and p._fivetran_deleted=false
        -- products
        join orchard_app_reporting_v2.art_relations_prod_art_relations.releases r on r.project_id=p.project_id and r._fivetran_deleted=false
        left join facts.prod.label_participant_participated_in_orchard_product lpp on lpp.product_id=r.release_id
        left join facts.prod.label_participant lp on lp.uuid = lpp.label_participant_uuid and lp.vendor_id=v.vendor_id
        -- tracks
        left join orchard_app_reporting_v2.art_relations_prod_art_relations.track t on t.release_id=r.release_id and t._fivetran_deleted=false
        left join facts.prod.label_participant_participated_in_orchard_track lpt on lpt.track_id=t.id
        left join facts.prod.label_participant lp2 on lp2.uuid = lpt.label_participant_uuid and lp2.vendor_id=v.vendor_id
        where true
        and not v._fivetran_deleted
        and v.migrated_to_abacus
        group by 1,2,3,4,5,6,7
    ;;
```