## ---------------------------------- ##
##    SCHEMAS                         ##
## ---------------------------------- ##
  
  spotify           :: Raw VIEW;  A few other older misc tables
  spot_metadata     :: SoS Metadata, scraped from API
  spot_user_counts  :: aggregate tables of user and stream counts


## ---------------------------------- ##
## TABLES -- spot_metadata            ##
## ---------------------------------- ##

  ALL_PLAYLIST_URIS ::  
    cols: playlist_uri | playlist_id | snapshot_id  | last_updated_tz
    comment: "Unique playlist uri with the latest known snapshot_id"
    populted from: spotify.sos_from_raw_view;  unique uri's not currently in ALL_PLAYLIST_URIS

  PLAYLIST_METADATA ::
    cols: id | uri | snapshot_id | name | owner_id | owner_uri | is_public | is_collaborative | followers_count | total_track_count | description | image_weblink | api_timestamp
    comment: