Updated on 2023-12-22 GMT+08:00

From MRS ClickHouse

If the source link of a job is an MRS ClickHouse link, configure the source job parameters based on Table 1.

Table 1 Parameter description

Category

Parameter

Description

Example Value

Basic parameters

Source Link Name

MRS ClickHouse link

ck_from_cdm

Schema/Tablespace

Click the icon next to the text box to go to the page for selecting a schema or directly enter a schema or tablespace.

If the desired schema or tablespace is not displayed, check whether the login account has the permissions required to query metadata.

NOTE:

This parameter can be set to a regular expression to export all databases that meet the rule.

default

Table Name

Click the icon next to the text box to go to the page for selecting the table or directly enter a table name.

If the desired table is not displayed, check whether the table exists or whether the login account has the permission to query metadata.

NOTE:

This parameter can be set to a regular expression to export all databases that meet the rule.

TBL_E

Advanced attributes

WHERE Clause

This parameter indicates the WHERE clause to be extracted. If this parameter is not set, the entire table is extracted. If the table to be migrated does not contain the fields specified by the WHERE clause, the migration will fail.

You can set a date macro variable to extract data generated on a specific date. For details, see Incremental Migration of Relational Databases.

NOTE:

If you have configured a macro variable of date and time and schedule a CDM job through DataArts Studio DataArts Factory, the system replaces the macro variable of date and time with (Planned start time of the data development jobOffset) rather than (Actual start time of the CDM jobOffset).

age > 18 and age <= 60