Query table from stream

Hello community,
i would like to create a stream from a stream. There should be a where clause to filter events depending on the last avg value inside a onther table.

Does have anybody an idea for a solution?

Thank you in advance!

BR
Simon

Can you please share an example?

CREATE STREAM AS SELECT is already possible.

If you want to use a table alongside that, you can JOIN on a field, not filter by some average.

If you want to use table lookups and filtering events, that’s where you’d probably need to use Kafka Streams.