How to Create Materialized View in ksqlDB

In ksqlDB, materialized views are tables that have a persistent query updating their physical state. See how to create a table from a query.

Note that they are also called materialized tables.

In contrast, non-materialized tables are the equivalent of traditional views. You are allowed to run push queries on non-materialized tables — with one caveat, the underlying state needs to be recreated on every query execution.