> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

> Use Fivetran to move data from any source into ClickHouse Cloud with automated schema creation, deduplication, and History Mode (SCD Type 2).

# Fivetran and ClickHouse Cloud

export const ClickHouseSupportedBadge = () => {
  return <div className="ClickHouseSupportedBadge">
            <div className="ClickHouseSupportedIcon">
                <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                    <path d="M1.30762 1.39073C1.30762 1.3103 1.37465 1.22986 1.46849 1.22986H2.64824C2.72868 1.22986 2.80912 1.29689 2.80912 1.39073V14.4886C2.80912 14.5691 2.74209 14.6495 2.64824 14.6495H1.46849C1.38805 14.6495 1.30762 14.5825 1.30762 14.4886V1.39073Z" fill="currentColor" />
                    <path d="M4.2832 1.39073C4.2832 1.3103 4.35023 1.22986 4.44408 1.22986H5.62383C5.70427 1.22986 5.7847 1.29689 5.7847 1.39073V14.4886C5.7847 14.5691 5.71767 14.6495 5.62383 14.6495H4.44408C4.36364 14.6495 4.2832 14.5825 4.2832 14.4886V1.39073Z" fill="currentColor" />
                    <path d="M7.25977 1.39073C7.25977 1.3103 7.3268 1.22986 7.42064 1.22986H8.60039C8.68083 1.22986 8.76127 1.29689 8.76127 1.39073V14.4886C8.76127 14.5691 8.69423 14.6495 8.60039 14.6495H7.42064C7.3402 14.6495 7.25977 14.5825 7.25977 14.4886V1.39073Z" fill="currentColor" />
                    <path d="M10.2354 1.39073C10.2354 1.3103 10.3024 1.22986 10.3962 1.22986H11.576C11.6564 1.22986 11.7369 1.29689 11.7369 1.39073V14.4886C11.7369 14.5691 11.6698 14.6495 11.576 14.6495H10.3962C10.3158 14.6495 10.2354 14.5825 10.2354 14.4886V1.39073Z" fill="currentColor" />
                    <path d="M13.2256 6.6057C13.2256 6.52526 13.2926 6.44482 13.3865 6.44482H14.5662C14.6466 6.44482 14.7271 6.51186 14.7271 6.6057V9.27354C14.7271 9.35398 14.6601 9.43442 14.5662 9.43442H13.3865C13.306 9.43442 13.2256 9.36739 13.2256 9.27354V6.6057Z" fill="currentColor" />
                </svg>
            </div>
            ClickHouse Supported
        </div>;
};

<ClickHouseSupportedBadge />

<h2 id="overview">
  Overview
</h2>

[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.
</Note>

<div class="vimeo-container">
  <Frame>
    <iframe
      src="//www.youtube.com/embed/sWe5JHW3lAs"
      frameborder="0"
      allow="autoplay;
fullscreen;
picture-in-picture"
      allowfullscreen
    />
  </Frame>
</div>

<h2 id="key-features">
  Key features
</h2>

* **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.

<h2 id="limitations">
  Limitations
</h2>

* 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/connectors/data-ingestion/etl-tools/fivetran/troubleshooting#role-based-grants) instead.

<h2 id="related-pages">
  Related pages
</h2>

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

<h2 id="setup-guide">
  Setup guide
</h2>

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

<h2 id="contact-us">
  Contact and support
</h2>

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/resources/about/support) to ask a question or report an issue.