# View: dt_content_validation_album_credit

**View Name:** dt_content_validation_album_credit
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_CONTENT_VALIDATION_ALBUM_CREDIT`
**File Path:** `dt_content_validation_album_credit.view.lkml`

## Overview

- **File Size:** 1385 bytes
- **Lines of Code:** 39
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- WITH track_artists_by_release AS (
- tr.release_id,

## Dimensions

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

## Derived Table

```sql
#    sql:
#WITH track_artists_by_release AS (
#    SELECT
#        tr.release_id,
#        ta.name AS track_artist,
#        COUNT(1) AS occurences
#    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.track_artist ta
#        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON ta.track_id = tr.id
#    WHERE ta.type = 'featuring'
#    GROUP BY 1,2
#),
#tracks_by_release AS (
#    SELECT release_id, COUNT(id) AS occurences
#    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.track
#    GROUP BY 1
#)
#SELECT DISTINCT tbr.release_id, tabr.track_artist AS missing_release_artist
#FROM tracks_by_release tbr
#    INNER JOIN track_artists_by_release tabr ON tbr.release_id = tabr.release_id
#    LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.release_artist ra ON tabr.release_id = ra.release_id AND tabr.track_artist = ra.artist_name
#WHERE tbr.occurences = tabr.occurences AND ra.artist_name IS NULL
#      ;;
#
```