# View: cm_unioned_playlist_past

**View Name:** cm_unioned_playlist_past
**Table Source:** `intelligence.dbt_prod.cm_unioned_playlist_past`
**File Path:** `cm_unioned_playlist_past.view.lkml`

## Overview

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

## Comments & Notes

- derived_table: {
- sql:with past_playlisting as (
- select cast(spotify as varchar) as "TRACK_ID", cast(spotify_playlist as varchar) as "PLAYLIST_ID", s.isrc as "ISRC",

## Dimensions

| Name | Type |
|------|------|
| `track_id` | string |
| `playlist_id` | string |
| `playlist_name` | string |
| `playlist_curator` | string |
| `store` | string |
| `peak_date` | date |
| `isrc` | string |

## Measures

| Name | Type |
|------|------|
| `past_position` | min |

## Dimension Groups

| Name | Type |
|------|------|
| `timestp` | time |

## Derived Table

```sql
#    sql:with past_playlisting as (

#select cast(spotify as varchar) as "TRACK_ID", cast(spotify_playlist as varchar) as "PLAYLIST_ID", s.isrc as "ISRC",
#sp.name as "PLAYLIST_NAME", sp.user_id as "PLAYLIST_CURATOR", (position+1) as "PAST_POSITION", 'Spotify' as "STORE",
#ps.timestp as "TIMESTP"
#from CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST_STAT ps
#left join CHARTMETRIC.RAW_DATA.SPOTIFY s on s.id = ps.spotify
#left join CHARTMETRIC.RAW_DATA.SPOTIFY_PLAYLIST sp on sp.id = ps.spotify_playlist

#union all

#select amazon as "TRACK_ID", amazon_playlist as "PLAYLIST_ID", a.isrc as "ISRC",
#ap.name as "PLAYLIST_NAME", ap.curator_name as "PLAYLIST_CURATOR", position as "PAST_POSITION", 'Amazon Music' as "STORE",
#ps.timestp as "TIMESTP"
#from CHARTMETRIC.RAW_DATA.L_AMAZON_PLAYLIST_STAT ps
#left join CHARTMETRIC.RAW_DATA.AMAZON a on a.id = ps.amazon
#left join CHARTMETRIC.RAW_DATA.AMAZON_PLAYLIST ap on ap.id = ps.amazon_playlist

#union all

#Select cast(itunes as varchar) as "TRACK_ID", cast(itunes_playlist as varchar) as "PLAYLIST_ID", i.isrc as "ISRC",
#ip.name as "PLAYLIST_NAME", ip.owner_name as "PLAYLIST_CURATOR", position as "PAST_POSITION", 'Apple Music' as "STORE",
#ps.timestp as "TIMESTP"
#from CHARTMETRIC.RAW_DATA.L_ITUNES_PLAYLIST_STAT ps
#left join CHARTMETRIC.RAW_DATA.ITUNES i on i.id = ps.itunes
#left join CHARTMETRIC.RAW_DATA.ITUNES_PLAYLIST ip on ip.id = ps.itunes_playlist

#union all

#Select cast(deezer as varchar) as "TRACK_ID", cast(deezer_playlist as varchar) as "PLAYLIST_ID", d.isrc as "ISRC",
#dp.name as "PLAYLIST_NAME", '' as "PLAYLIST_CURATOR", position as "PAST_POSITION", 'Deezer' as "STORE",
#ps.timestp as "TIMESTP"
#from CHARTMETRIC.RAW_DATA.L_DEEZER_PLAYLIST_STAT ps
#left join CHARTMETRIC.RAW_DATA.DEEZER d on d.id = ps.deezer
#left join CHARTMETRIC.RAW_DATA.DEEZER_PLAYLIST dp on dp.id = ps.deezer_playlist

#union all

#Select  video_id as "TRACK_ID", playlist_id as "PLAYLIST_ID", y.isrc as "ISRC",
#yp.name as "PLAYLIST_NAME", '' as "PLAYLIST_CURATOR", position as "PAST_POSITION", 'YouTube' as "STORE",
#ps.timestp as "TIMESTP"
#from CHARTMETRIC.RAW_DATA.L_YOUTUBE_PLAYLIST_STAT ps
#left join CHARTMETRIC.RAW_DATA.YOUTUBE y on y.id = ps.video_id
#left join CHARTMETRIC.RAW_DATA.YOUTUBE_PLAYLIST yp on yp.id = ps.playlist_id)

#select *
#from past_playlisting;;
#
```