The ClickHouse® connector

Select the Connection type:

Specify the Database name in the cluster.

Specify the User of the database for connection to Transfer service.

Enter the Password for the database user.

Specify additional settings:

• Included tables. The Transfer service will transfer only the data from these tables. Specify regular expressions to select tables.

• Excluded tables. The data from the tables on this list won't be transferred. Specify regular expressions to select tables.

Select the connection type:

Specify the name of a Database in your cluster.

Specify the User of the database for connection to the Transfer service.

Enter the Password for the database user.

Specify Advanced settings:

1. Under Rename tables:

   1. Click + Table.

   2. Provide the name you want to change in Source table name.

   3. Write a new name in Target table name. If the Target endpoint has the table with the same name, the data will be written into the existing table.

   Merge multiple tables with renaming

   You can merge data from several Source endpoint tables into a single one at your Target endpoint. To perform this, create Rename table instances with different Source table name values and the same Target table name ones.

   For this feature to work, ensure the data schemas on the source and target tables are the same.

2. Specify Sharding field.

3. If you need Sharding by a transfer ID, click this checkbox.

   Warning

   If both Sharding field and Sharding by transfer ID are active, sharding is performed by transfer ID only.

4. Under Explicit sharding function you can specify routes of data transfer to specific shards.

   1. Click Add Mapping rule.

   2. Specify the data in Column value.

   3. Enter the Shard name to which you want to transfer data.

   When you use an Explicit sharding function, specify the data type in Sharding field.

5. If you need to Upload data in JSON format, click this checkbox.

6. Specify Flush interval in seconds.

   Warning

   The Flush interval field must contain an expression with a number and an s postfix, for example, 7s.

7. Select a Cleanup policy. This policy allows you to select a way to clean up data in the target database when you activate, reactivate or reload the transfer:

   • Disabled: Do not clean. Select this option if you only perform replication without copying data.

   • Drop: Fully delete the tables included in the transfer (default). Use this option to always transfer the latest version of the table schema to the target database from the source.

   • Truncate: Execute the TRUNCATE command for a target table each time you run a transfer.