CREATE NAMED COLLECTION

Creates a new named collection.

DDL-created named collections can be enabled on select ClickHouse Cloud services. Contact Support to confirm availability.

Syntax

CREATE NAMED COLLECTION [IF NOT EXISTS] name [ON CLUSTER cluster] AS
key_name1 = 'some value' [[NOT] OVERRIDABLE],
key_name2 = 'some value' [[NOT] OVERRIDABLE],
key_name3 = 'some value' [[NOT] OVERRIDABLE],
...

Example

CREATE NAMED COLLECTION foobar AS a = '1', b = '2' OVERRIDABLE;

Related statements

CREATE NAMED COLLECTION
DROP NAMED COLLECTION

See Also

Named collections guide

Part of: CREATE

Last modified on August 25, 2026

SQL Reference

Data Types

Engines

Functions

Formats

Interfaces

Settings

System Tables

Data Lakes