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 you to load data from various sources into ClickHouse. Open Source ClickHouse version isn't supported as a 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​

  • ClickHouse Cloud compatible: use your ClickHouse Cloud database as a Fivetran destination.
  • SaaS deployment model: fully managed by Fivetran, no need to manage your own infrastructure.
  • History Mode (SCD Type 2): preserves complete history of all record versions for point-in-time analysis and audit trails.
  • Configurable batch sizes: You can adapt Fivetran to your particular use case by tuning write, select, mutation, and hard delete batch sizes via a JSON configuration file.

Limitations​

  • Schema migrations are not supported yet, but we are working on it.
  • 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.

Setup guide​

  • If you're looking for configurations and general technical details, please refer to the technical reference.
  • For a comprehensive guide, check the setup guide in the Fivetran documentation.

Contact and support​

The ClickHouse Fivetran destination has a split ownership model:

  • ClickHouse develops and maintains the destination connector code.
  • Fivetran hosts the connector and is responsible for data movement, pipeline scheduling, and source connectors.

Both Fivetran and ClickHouse provide support for the Fivetran ClickHouse destination. For general inquiries, we recommend reaching out to Fivetran, as they are the experts on the Fivetran platform. For any ClickHouse-specific questions or issues, our support team is happy to help. Create a support ticket to ask a question or report an issue.