CREATE OR REPLACE TABLE DEV_ENGINEERING.RBOMBERG_DBT.RELATED_ARTISTS AS select * from
(
SELECT a_.SPOTIFY_ARTIST_ID AS main_artist,
       sra.RELATED_ARTIST_ID,
       sa2.ARTIST_NAME,
       sa2.FOLLOWERS_LATEST
FROM DEV_ENGINEERING.RBOMBERG_DBT.spotify_artists a_
         INNER JOIN chartmetric.raw_data.spotify_related_artist sra
             ON a_.SPOTIFY_ARTIST_ID = sra.SPOTIFY_ARTIST_ID
         INNER JOIN chartmetric.raw_data.spotify_artist sa
             ON sra.SPOTIFY_ARTIST_ID = sa.SPOTIFY_ARTIST_ID
         LEFT JOIN chartmetric.raw_data.spotify_artist sa2
             ON sra.RELATED_ARTIST_ID = sa2.SPOTIFY_ARTIST_ID
ORDER BY 1, 4 DESC
) source;