# View: cm_release_label

**View Name:** cm_release_label
**Table Source:** `INTELLIGENCE.DBT_PROD.CM_RELEASE_LABEL`
**File Path:** `cm_release_label.view.lkml`

## Overview

- **File Size:** 1348 bytes
- **Lines of Code:** 58
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: with labels as (Select t.isrc, a.upc, a.name as release_name, a.release_date, a.label as release_label
- from CHARTMETRIC.RAW_DATA.CM_ALBUM a

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |
| `upc` | string |
| `release_label` | string |
| `release_name` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `Date` | time |

## Derived Table

```sql
#    sql: with labels as (Select t.isrc, a.upc, a.name as release_name, a.release_date, a.label as release_label
#from CHARTMETRIC.RAW_DATA.CM_ALBUM a
#left join CHARTMETRIC.RAW_DATA.L_CM_TRACK_CM_ALBUM ta on a.id = ta.cm_album
#inner join CHARTMETRIC.RAW_DATA.CM_TRACK t on ta.cm_track = t.id
#order by a.upc),
#
#labels_singular as (SELECT *
#FROM labels l INNER JOIN
#    (
#        SELECT isrc as isrc2, MIN(release_date) AS MinDate
#        FROM labels
#        GROUP BY isrc2
#    ) t ON l.isrc = t.isrc2 AND l.release_date = t.MinDate)
#
#select *, listagg(distinct(release_label), '| ')
#within group (order by release_label)
#over (partition by isrc2) as labels
#from labels_singular;;
#
```