Skip to main content
Skip to main content
Edit this page

Fivetran and ClickHouse Cloud

ClickHouse Supported

Overview​

Fivetran is the automated data movement platform moving data out of, into and across your cloud data platforms.

ClickHouse Cloud is supported as a Fivetran destination, allowing users to load data from various sources into ClickHouse. Open Source ClickHouse version is not supported as destination.

The destination connector is developed and maintained together by ClickHouse and Fivetran. The source code is available on GitHub.

Note

ClickHouse Cloud destination is currently in Beta but we are working to make it generally available soon.

Key features​

  • Automatic schema creation — destination tables and databases are created automatically based on source schema.
  • History Mode (SCD Type 2) — preserves complete history of all record versions for point-in-time analysis and audit trails.
  • Retry on network failures — transient network errors are retried with exponential backoff. Duplicates from retries are handled by ReplacingMergeTree.
  • Configurable batch sizes — tune write, select, mutation, and hard delete batch sizes via a JSON configuration file.

Limitations​

  • Adding, removing, or modifying primary key columns is not supported.
  • Custom ClickHouse settings on CREATE TABLE statements are not supported.
  • Role-based grants are not fully supported — the connector's grants check only queries direct user grants. Use direct grants instead.

Additional resources​