Indexing the Data Lake for Online Point Queries

(engineering.atspotify.com)

14 points | by kalaracey 1 hour ago

2 comments

  • giovannibonetti 0 minutes ago
    [delayed]
  • aleda145 16 minutes ago
    Pretty clever to keep the existing parquet files as is (assuming daily partitioned) to not break any analytical queries. Also creating this index for the first time would make me sweat. With exabytes in the lake, the backfill bill will be $$$ (even just scanning the key column).

    I'm not sure about the AI agent angle though, why would it need that specific context on a user level? I guess they are exploring a "chat with my spotify history" or user generated playlists?

    (also the article has several LLM smells. It's technically interesting but reads like slop at times)