v.25.10New Feature

Alias engine creates a proxy

Official CH changelog text
The Alias engine creates a proxy to another table. All read and write operations are forwarded to the target table, while the alias itself stores no data and only maintains a reference to the target table. #87965 (Kai Zhu).
The Alias table engine acts as a proxy to another table, forwarding all read and write operations to the target without storing any data itself.

Why it matters

This feature simplifies table management by allowing users to create lightweight aliases that reference existing tables. It eliminates data duplication and provides a convenient way to rename or redirect tables without impacting the underlying data storage.

How to use it

To use the Alias engine, create a table with the Alias engine specifying the target table name. For example:

CREATE TABLE alias_table_name ENGINE = Alias('original_table_name');

All queries against the alias table will be transparently forwarded to the target table.

Related resources

PreviousNext