Learn how to manage ClickHouse schemas with Atlas using both declarative and versioned workflows. This guide covers automatic ClickHouse schema migration, inspection, migration planning, and applying changes via CLI and CI/CD integrations.
All common open-source relational database management systems are supported in all versions of Atlas.
This guide walks you through managing ClickHouse Cloud databases using Atlas, covering connection setup, development database considerations, and best practices for cloud environments.
Introduction
Managing schema changes in ClickHouse clusters with Atlas requires understanding several key concepts. While Atlas works seamlessly with both single-node and cluster deployments, cluster mode introduces specific considerations that must be addressed to ensure reliable schema management.
While Atlas supports defining engines as simple enums in HCL (like MergeTree or SharedMergeTree), many ClickHouse features require more complex configurations. Atlas provides the sql() function to handle these advanced scenarios.