Databases, tables, and views in Managed ClickHouse®
Databases, tables, and views organize data in Managed ClickHouse®. A database groups related tables and other database objects. Tables store data using table engines that define how data is stored, replicated, and queried. Views and materialized views help query, transform, or precompute data.
You can create and manage databases and tables with SQL.
Databases
A database groups related tables, views, and other objects. Databases you create with SQL
on Managed ClickHouse always use the Replicated engine, which keeps their metadata
consistent across the nodes of the service.
Tables
A table stores data in rows and columns. Each table uses a table engine that controls storage behavior, indexing, replication, and data lifecycle features.
Views and materialized views
Views and materialized views help query or transform data. A materialized view stores query results and can improve performance for repeated queries or pre-aggregated data.
Engines
How data is stored and queried depends on the engines you choose:
- Table engines define how data is stored on disk or read from external sources.
- Database engines control how a database manages its tables and metadata.
Engine availability can vary by Managed ClickHouse service version.