CREATE
OR REPLACE TABLE DEV_ENGINEERING.RBOMBERG_DBT.SPOTIFY_ARTISTS_PLAYLISTS AS
SELECT main.*
FROM (
         SELECT DISTINCT A.value AS SPOTIFY_ARTIST_ID,
                         pl.SPOTIFY_PLAYLIST,
                         sp.user_id,
                         sp.owner_name,
                         sp.playlist_id,
                         sp.name as playlist_name
         FROM CHARTMETRIC.raw_data.spotify spot
                  INNER JOIN CHARTMETRIC.raw_data.l_spotify_playlist pl ON spot.id = pl.spotify
                  INNER JOIN CHARTMETRIC.raw_data.spotify_playlist sp ON sp.id = pl.spotify_playlist,
              LATERAL SPLIT_TO_TABLE(spot.SPOTIFY_ARTIST_ID,',') A
         WHERE sp.user_id='spotify'
     ) main
         INNER JOIN
     (
         SELECT spotify_artist_id AS sp_artist_id FROM DEV_ENGINEERING.RBOMBERG_DBT.spotify_artists
     ) art ON main.SPOTIFY_ARTIST_ID = art.sp_artist_id;