# View: spot_metadata.playlist_metadata

**View Name:** spot_metadata_playlist_metadata
**Table Source:** `Derived from: Prod.Spotify_Playlists_Cache`
**File Path:** `spot_metadata.playlist_metadata.view.lkml`

## Overview

- **File Size:** 8307 bytes
- **Lines of Code:** 281
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- <div style="min-width: 100px; font-size:105%; font-weight:bold;">
- <A HREF = "http://open.spotify.com/user/{{ owner_id._value }}/playlist/{{ id._value }}" TARGET="_blank">{{ value }}</A>
- ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   START Manually Added   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##

## Dimensions

| Name | Type |
|------|------|
| `id` | string |
| `name` | string |
| `date_added` | date |
| `playlist_author` | string |
| `isrc` | number |

## Derived Table

```sql
sql: select
      distinct spc.playlist_id as playlist_id, spc.playlist_name as playlist_name, spc.playlist_author as playlist_author, spc.date_added
      from facts.prod.spotify_playlists_cache spc
      inner join
       (select max(date_added) as max_date_added, playlist_id from facts.prod.spotify_playlists_cache group by 2)
         sp on spc.playlist_id = sp.playlist_id and spc.date_added = sp.max_date_added
       ;;
```