ALIYUN::ClickHouse::SynDb is used to create a synchronization task for an ApsaraDB for ClickHouse Community-compatible Edition cluster.
Syntax
{
"Type": "ALIYUN::ClickHouse::SynDb",
"Properties": {
"RdsVpcUrl": String,
"LimitUpper": Integer,
"SkipUnsupported": Boolean,
"RdsId": String,
"RdsPassword": String,
"RdsUserName": String,
"CkPassword": String,
"CkUserName": String,
"ClickhousePort": Integer,
"SynDbTables": List,
"DbClusterId": String,
"RdsPort": Integer,
"RdsVpcId": String
}
}
Properties
Property | Type | Required | Editable | Description | Constraint |
RdsVpcUrl | String | No | No | The private endpoint of the ApsaraDB RDS for MySQL instance. | None. |
LimitUpper | Integer | No | No | The maximum number of rows that can be synchronized per second. | None. |
SkipUnsupported | Boolean | Yes | No | Specifies whether to ignore the table schemas that do not support synchronization. | Valid values:
|
RdsId | String | Yes | No | The ID of the ApsaraDB RDS for MySQL instance. | None. |
RdsPassword | String | Yes | No | The password of the account that is used to log on to the ApsaraDB RDS for MySQL database. | None. |
RdsUserName | String | Yes | No | The account that is used to log on to the ApsaraDB RDS for MySQL database. | None. |
CkPassword | String | Yes | No | The password of the account that is used to log on to the database in the ApsaraDB for ClickHouse cluster. | None. |
CkUserName | String | Yes | No | The account that is used to log on to the database in the ApsaraDB for ClickHouse cluster. | None. |
ClickhousePort | Integer | No | No | The port number of ApsaraDB for ClickHouse. | None. |
SynDbTables | List | Yes | No | The tables whose data you want to synchronize. | For more information, see SynDbTables properties. |
DbClusterId | String | Yes | No | The ID of the ApsaraDB for ClickHouse cluster. | None. |
RdsPort | Integer | No | No | The port number of the ApsaraDB RDS for MySQL instance. | None. |
RdsVpcId | String | No | No | The ID of the virtual private cloud (VPC) to which the ApsaraDB RDS for MySQL instance belongs. | None. |
SynDbTables syntax
"SynDbTables": [
{
"Schema": String,
"Tables": List
}
]
SynDbTables properties
Property | Type | Required | Editable | Description | Constraint |
Schema | String | Yes | No | The database name. | None. |
Tables | List | Yes | No | The information about the tables. | None. |
Return values
Fn::GetAtt
SynDbs: the synchronized data.
DbClusterId: the ID of the ApsaraDB for ClickHouse cluster.
RdsId: the ID of the ApsaraDB RDS for MySQL instance.