# View: dt_editorial_playlists

**View Name:** dt_editorial_playlists
**Table Source:** `Derived from: Dbsony_Dbo.Tblapplemusicplaylist, Dbsony_Dbo.Tblspotifyplaylist, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Dbsony_Dbo`
**File Path:** `dt_editorial_playlists.view.lkml`

## Overview

- **File Size:** 1201 bytes
- **Lines of Code:** 51
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `storeid` | number |
| `playlist_id` | string |
| `playlist_name` | string |
| `playlist_is_editorial` | yesno |

## SQL Comments

- playlisturi AS store_link,
- user AS store_source,
- playlisttype,

## Derived Table

```sql
sql:
SELECT DISTINCT
    286 AS store_id,
    --playlisturi AS store_link,
    TRIM(SPLIT_PART(playlisturi,':',3)) AS playlist_id,
    name AS playlist_name,
    --user AS store_source,
    IFF(CONTAINS(user,'spotify'), TRUE, FALSE) AS is_editorial
FROM orchard_app_reporting_v2.dbsony_dbo.tblspotifyplaylist
UNION ALL
SELECT DISTINCT
    1 AS store_id,
    --id,
    TRIM(SPLIT_PART(id,'.',2)) AS playlist_id,
    name AS playlist_name,
    --playlisttype,
    CASE playlisttype
        WHEN 'editorial' THEN TRUE
        WHEN 'playlists' THEN TRUE
        ELSE FALSE
    END AS is_editorial
FROM orchard_app_reporting_v2.dbsony_dbo.tblapplemusicplaylist ;;
```