troubleshooting

How to enrich events with joins against external database in RisingWave?

I am trying to enrich events with joins against an external database in RisingWave. The traditional methods like windowed join or UDF don't seem correct. Is there another way to achieve this?

Do

Dominic Lindsay

Asked on Aug 17, 2023

  1. Use create table for the lookup-side table and join the input data with it.

  2. Replicate the external data by using RisingWave to keep the lookup-side table in sync with the upstream data source.

  3. Populate the table with the contents by creating a table with a connector.

  4. The table will be kept in sync with the upstream data source, such as a database table.

  5. Refer to the RisingWave documentation on create table for more information: RisingWave Create Table Documentation

Aug 17, 2023Edited by