v.24.10Improvement

Support for Atomic CREATE OR REPLACE VIEW

Support for atomic CREATE OR REPLACE VIEW. #70536 (tuanpach)
Added support for atomic CREATE OR REPLACE VIEW statements in ClickHouse.

Why it matters

This feature allows users to atomically create or replace a view, ensuring that the operation is done safely without intermediate inconsistent states. It simplifies view management and reduces the risk of errors when updating views.

How to use it

Users can use the CREATE OR REPLACE VIEW syntax in their SQL queries to create a new view or replace an existing one atomically. For example:

CREATE OR REPLACE VIEW view_name AS
SELECT ... FROM ...;