Fivetran and ClickHouse Cloud

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/integrations/data-ingestion/etl-tools/fivetran/index.md)

ClickHouse Supported

## Overview[​](#overview "Direct link to Overview")

[Fivetran](https://www.fivetran.com) is the automated data movement platform moving data out of, into and across your cloud data platforms.

[ClickHouse Cloud](https://clickhouse.com/cloud) is supported as a [Fivetran destination](https://fivetran.com/docs/destinations/clickhouse), 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](https://github.com/ClickHouse/clickhouse-fivetran-destination).

Note

[ClickHouse Cloud destination](https://fivetran.com/docs/destinations/clickhouse) is currently in **Beta** but we are working to make it generally available soon.

## Key features[​](#key-features "Direct link to 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[​](#limitations "Direct link to 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](/docs/integrations/fivetran/troubleshooting#role-based-grants) instead.

## Related pages[​](#related-pages "Direct link to Related pages")

- [Technical Reference](/docs/integrations/fivetran/reference): type mappings, table engines, metadata columns and advanced configurations
- [Troubleshooting & Best Practices](/docs/integrations/fivetran/troubleshooting): common errors and optimization tips and debugging queries
- [ClickHouse Fivetran destination on GitHub](https://github.com/ClickHouse/clickhouse-fivetran-destination)

## Setup guide[​](#setup-guide "Direct link to Setup guide")

- If you're looking for configurations and general technical details, please refer to the [technical reference](/docs/integrations/fivetran/reference).
- For a comprehensive guide, check the [setup guide](https://fivetran.com/docs/destinations/clickhouse/setup-guide) in the Fivetran documentation.

## Contact and support[​](#contact-us "Direct link to 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](/docs/about-us/support) to ask a question or report an issue.

- [Overview](#overview)- [Key features](#key-features)- [Limitations](#limitations)- [Related pages](#related-pages)- [Setup guide](#setup-guide)- [Contact and support](#contact-us)

Was this page helpful?