Stream–Table Joins

The fact (stream) meets the dimension (table) — without nightly ETL.

0/3 done

Three kinds of join

Joins in motion

  • stream–stream join — windowed; you must say within how long.
  • stream–table join — point lookup at processing time; the table is your slow-moving dimension (users, products, currencies).
  • table–table join — keep two materialised views in sync.

Stream–table is by far the most common: enrich an order event with the current user tier.

ksqlDB: enrich orders with users

Define users_table (a compacted topic), then a continuous query that joins orders_stream to it and emits enriched events.

Reading in progress · 0 of 3 activities done