Copy data between Clusters

The Copy Data Wizard is on the TOOLS menu in the Clusters view:

The wizard makes it easy to copy data from one ClickHouse® cluster to another. To get started, select the location of the cluster (local or external) and the name of your Altinity.Cloud environment. With those two values selected, the Cluster drop-down menu will be populated with the names of the clusters in that environment. As you would expect, you also have to enter your username and password to access the cluster.

Here’s how things look when the data source is a local cluster:

Figure 1 - Copying data from a local cluster

If you’re copying from an external ClickHouse server, you’ll need to enter the server’s URL:

Figure 2 - Copying data from an external cluster

The second step of the wizard is selecting the data’s destination. Here’s how things look for a local destination:

Figure 3 - Copying data to a local cluster

As you’d expect, you can copy to an external cluster as well:

Figure 4 - Copying data to an external cluster

With your source and destination clusters selected, you have the option of selecting which tables will be copied. The default is All tables, but you can also choose to Select specific tables:

Figure 5 - Selecting specific tables to copy

Click the button to start copying data.