MRS ClickHouse Link Parameters

Table 1 describes the MRS ClickHouse link parameters.

Do not change the password or user when the job is running. If you do so, the password will not take effect immediately and the job will fail.

**Table 1** ClickHouse link parameters
Parameter	Description	Example Value
Name	Link name	cklink
Database Server	IP address or domain name of the database to connect NOTE: DataArts Studio does not support MRS clusters whose Kerberos encryption type is aes256-sha2,aes128-sha2, and only supports MRS clusters whose Kerberos encryption type is aes256-sha1,aes128-sha1. Log in to Manager of the cluster where the MRS ClickHouse data source is located, choose Cluster > Services > ClickHouse > Instance, and view the ClickHouseServer service IP address.	192.168.0.1
Port	Port of the database to connect NOTE: If the Server node is used, enable SSL Encryption and set the default port. Log in to the Manager of the cluster where the MRS ClickHouse data source is located, choose Cluster > Services > ClickHouse > Instance, and set the default port of ClickHouseServer. For an MRS cluster in non-security mode, set it to the value of the http_port parameter. For an MRS cluster in security mode, set it to the value of the https_port parameter. If the Balancer node is used, enable SSL Encryption and set the default port. Log in to the Manager of the cluster where the MRS ClickHouse data source is located, choose Cluster > Services > ClickHouse > Instance, and set the default port of ClickHouseBalancer. For an MRS cluster in non-security mode, set it to the value of the lb_http_port parameter. For an MRS cluster in security mode, set it to the value of the lb_https_port parameter. If MRS ClickHouse is deployed in a security cluster, set this parameter to the default HTTPS port.	8123
Database Name	Name of the database to connect	dbname
Username	Username used for accessing the database. This user must have the permissions to read and write data tables and metadata.	cdm
Password	Password of the user	-
SSL Encryption	(Optional) If you set this parameter to Yes, CDM can connect to the database (on-premises databases excluded) in SSL encryption mode.	No
Reference Sign	(Optional) Delimiter between the names of the referenced tables or columns. For details, see the product documentation of the corresponding database.	'