Back to Materialize

Ingest Data Kafka Debezium View

doc/user/layouts/shortcodes/ingest-data/ingest-data-kafka-debezium-view.md

123290 B
Original Source

A view saves a query under a name to provide a shorthand for referencing the query. During view creation, the underlying query is not executed.

mzsql
CREATE VIEW cnt_table1 AS
    SELECT field1,
           COUNT(*) AS cnt
    FROM kafka_repl
    GROUP BY field1;