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?
Dominic Lindsay
Asked on Aug 17, 2023
Use create table
for the lookup-side table and join the input data with it.
Replicate the external data by using RisingWave to keep the lookup-side table in sync with the upstream data source.
Populate the table with the contents by creating a table with a connector.
The table will be kept in sync with the upstream data source, such as a database table.
Refer to the RisingWave documentation on create table
for more information: RisingWave Create Table Documentation