v.19.17New Feature

Add the Ability to Create Dictionaries with DDL Queries

Add the ability to create dictionaries with DDL queries. #7360 (alesapin)
Added support for creating dictionaries using DDL queries in ClickHouse.

Why it matters

This feature enables users to define and create dictionaries directly through DDL statements, simplifying dictionary management and integration within database schemas. It improves usability by allowing dictionaries to be versioned and managed using standard SQL-like syntax instead of manual configuration files.

How to use it

Users can create dictionaries by writing CREATE DICTIONARY DDL queries. These queries specify dictionary structure, source, and layout, allowing dictionaries to be created, altered, or dropped as part of regular DDL workflows.