Skip to main content
Skip to main content

Migrating Data into ClickHouse


There are several options for migrating data into ClickHouse Cloud, depending on where your data resides now:

  • Self-managed to Cloud: use the remoteSecure function to transfer data
  • Another DBMS: use the [clickhouse-local] ETL tool along with the appropriate ClickHouse table function for your current DBMS
  • Anywhere!: use one of the many popular ETL/ELT tools that connect to all kinds of different data sources
  • Object Storage: easily insert data from S3 into ClickHouse

In the example Migrate from Redshift, we present three different ways to migrate data to ClickHouse.

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free