Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Offline Jobs)/ Configuring Connection Properties/ Configuring ClickHouse Connection Properties
Updated on 2026-05-20 GMT+08:00
View PDF
Share

Configuring ClickHouse Connection Properties

When using DataArts Migration, you can configure properties of the JDBC connection to the ClickHouse data source to optimize the data migration process and resolve possible problems.

This section describes the connection properties. You can click Add to add JDBC properties of the connection to a specified data source and configure the properties by referring to the JDBC connector documentation of the corresponding database.

Common Connection Properties

Table 1 Common connection properties

Property

Type

Description

connectTimeout

int (unit: ms)

Connection timeout interval. When a large amount of data needs to be migrated or the entire table is retrieved using query statements, the migration may fail due to connection timeout. To prevent such failures, you can customize the connection timeout interval. Example: connectTimeout=360000.

socketTimeout

int (unit: ms)

Socket timeout interval. When a large amount of data needs to be migrated or the entire table is retrieved using query statements, the migration may fail due to socket timeout. To prevent such failures, you can customize the socket timeout interval. Example: socketTimeout=360000.

Configuration Method

  1. On the Management Center page, locate the ClickHouse data source configuration.
  2. In the connection property configuration area, click Add to add properties for the connection.
  3. Enter property names and values as needed based on the descriptions in the preceding table.
  4. Save the change and test the connection to ensure that the configuration takes effect and data can be migrated properly.

Precautions

  • When configuring connection properties, ensure that you understand the meaning and function of each property to avoid data migration failures or other issues due to incorrect configurations.
  • If you have any questions during the configuration, refer to the official ClickHouse client documentation for more information and instructions.
  • You are advised to adjust and optimize connection properties based on the data migration scenarios and requirements to achieve optimal migration performance.

By properly configuring ClickHouse connection properties, you can improve data migration stability and efficiency for smooth data integration.