Skip to content
ClickHouse Docs
49.6kGet Started

MaterializedView

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

Stores the result of a SELECT query and keeps it up to date. When data is inserted into the source table referenced in the query, the materialized view applies the query to the new rows and stores the result in its target table. A MaterializedView is normally created with the CREATE MATERIALIZED VIEW statement.

Syntax

CREATE MATERIALIZED VIEW name [TO target] AS SELECT ...

Related

  • View
Navigation