From MRS ClickHouse¶
If the source link of a job is an MRS ClickHouse link, configure the source job parameters based on Table 1.
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. 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 job - Offset) rather than (Actual start time of the CDM job - Offset). | age > 18 and age <= 60 |