How to Materialize Table in ksqlDB

The main reason to materialize a table is to run pull queries on it.

Pull queries are faster and more optimized than push queries, as they keep the latest computed record per value in the primary key.

The following is an example of how we would create a materialized table from a non-materialized one:

CREATE TABLE scores_table_materialized
AS SELECT *
FROM scores_table_non_materialized
EMIT CHANGES;