DescribeDBClusterAttribute - ApsaraDB for ClickHouse - Alibaba Cloud Documentation Center

Queries the details of a specified ApsaraDB for ClickHouse cluster.

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

The table below describes the authorization required to call this API. You can define it in a Resource Access Management (RAM) policy. The table's columns are detailed below:

Action: The actions can be used in the Action element of RAM permission policy statements to grant permissions to perform the operation.
API: The API that you can call to perform the action.
Access level: The predefined level of access granted for each API. Valid values: create, list, get, update, and delete.
Resource type: The type of the resource that supports authorization to perform the action. It indicates if the action supports resource-level permission. The specified resource must be compatible with the action. Otherwise, the policy will be ineffective.
- For APIs with resource-level permissions, required resource types are marked with an asterisk (*). Specify the corresponding Alibaba Cloud Resource Name (ARN) in the Resource element of the policy.
- For APIs without resource-level permissions, it is shown as All Resources. Use an asterisk (*) in the Resource element of the policy.
Condition key: The condition keys defined by the service. The key allows for granular control, applying to either actions alone or actions associated with specific resources. In addition to service-specific condition keys, Alibaba Cloud provides a set of common condition keys applicable across all RAM-supported services.
Dependent action: The dependent actions required to run the action. To complete the action, the RAM user or the RAM role must have the permissions to perform all dependent actions.

Action

Access level

Resource type

Condition key

Dependent action

clickhouse:DescribeDBClusterAttribute

get

*All Resource

*

None

Request parameters

Parameter	Type	Required	Description	Example
DBClusterId	string	Yes	The cluster ID. Call the DescribeDBClusters operation to query the information about all clusters in a region, including the cluster IDs.	cc-bp108z124a8o7****

Response elements

Element	Type	Description	Example
	object	The response.
DBCluster	object	The details of the cluster.
VpcId	string	The VPC ID.	vpc-bp10tr8k9qasioaty****
SupportBackup	integer	Indicates whether data backup is supported. Valid values: 1: Data backup is supported. 2: Data backup is not supported.	1
SupportOss	integer	Indicates whether data tiering is supported. Valid values: 1: Data tiering is supported. 2: Data tiering is not supported.	1
EncryptionType	string	The encryption type. Valid values: CloudDisk: disk encryption. off: Encryption is disabled.	CloudDisk
DBNodeCount	integer	The number of nodes. For a single-replica edition, the value ranges from 1 to 48. For a double-replica edition, the value ranges from 1 to 24.	1
MaintainTime	string	The maintenance window of the cluster. The format is HH:mmZ-HH:mmZ (UTC). Example: 00:00Z-01:00Z. This means that routine maintenance can be performed from 00:00 to 01:00 UTC, which is 08:00 to 09:00 UTC+8.	00:00Z-01:00Z
CreateTime	string	The time when the cluster was created. The format is yyyy-MM-ddTHH:mm:ssZ (UTC).	2021-12-13T11:33:11Z
PayType	string	The billing method. Valid values: Postpaid: pay-as-you-go. Prepaid: subscription.	Prepaid
Tags	object
Tag	array<object>	The list of tags.
	object	A tag.
Key	string	The name of the tag.	department
Value	string	The value of the tag.	it
PublicConnectionString	string	The public endpoint.	cc-bp1199ya710s7****.public.clickhouse.ads.aliyuncs.com
StorageType	string	The storage class. Valid values: CloudESSD: ESSD PL1 cloud disk. CloudESSD_PL2: ESSD PL2 cloud disk. CloudESSD_PL3: ESSD PL3 cloud disk. CloudEfficiency: ultra disk.	CloudESSD
Port	integer	The HTTP port number.	8123
LockMode	string	The lock mode of the cluster. Valid values: Unlock: The cluster is not locked. ManualLock: The cluster is manually locked. LockByExpiration: The cluster is automatically locked due to expiration. LockByRestoration: The cluster is automatically locked before a rollback. LockByDiskQuota: The cluster is automatically locked because the storage space is full.	Unlock
Bid	string	The site ID. Valid values: 26842: Alibaba Cloud China Website (www.aliyun.com). 26888: Alibaba Cloud International Website (www.alibabacloud.com).	26842
EngineVersion	string	The database engine version.	21.8.10.19
IsExpired	string	Indicates whether the cluster has expired. Valid values: true: The cluster has expired. false: The cluster has not expired.	false
ScaleOutStatus	object	The data migration status.
Progress	string	The percentage of migrated data. Note This parameter is returned only when the cluster is in the SCALING_OUT state.	0
Ratio	string	The progress of data migration. The format is: Migrated data volume/Total data volume. Note This parameter is returned only when the cluster is in the SCALING_OUT state.	0MB/60469MB
LbKind	string
DBClusterId	string	The cluster ID.	cc-bp108z124a8o7****
ConnectionString	string	The VPC endpoint.	cc-bp1qx68m06981****.ads.rds.aliyuncs.com
EncryptionKey	string	The KMS key. Note If the encryption type is off, an empty value is returned.	685f416f-87c9-4554-8d3a-75b6ce25****
DBClusterType	string	The cluster type. Valid values: Common: a regular cluster. Readonly: a read-only cluster. Guard: a disaster recovery cluster.	Common
CommodityCode	string	The commodity code.	clickhouse_go_public_cn
ExpireTime	string	The expiration time of the cluster. The format is yyyy-MM-ddTHH:mm:ssZ. Note Pay-as-you-go clusters do not have an expiration time. An empty value is returned for this parameter.	2022-11-11T16:00:00Z
DBNodeStorage	integer	The storage space of a single node. Unit: GB. Value range: 100 to 32000. Note The step size is 100 GB.	100
DBNodeClass	string	The cluster specifications. For a single-replica edition, valid values are: S4-NEW S8 S16 S32 S64 S104 For a double-replica edition, valid values are: C4-NEW C8 C16 C32 C64 C104	C8
AliUid	string	The Alibaba Cloud account ID.	140692647406****
LockReason	string	The reason why the cluster is locked. Note If the lock mode is Unlock, an empty value is returned.	DISK_FULL
RegionId	string	The region ID.	cn-hangzhou
PublicPort	string	The public TCP port number.	3306
VSwitchId	string	The vSwitch ID.	vsw-bp1n874li1t5y57wi****
DBClusterStatus	string	The cluster state. Valid values: Preparing: The cluster is being prepared. Creating: The cluster is being created. Running: The cluster is running. Deleting: The cluster is being deleted. SCALING_OUT: The cluster is scaling up.	Running
DBClusterNetworkType	string	The network type. Only VPC is supported.	vpc
DBClusterDescription	string	The cluster description.	cc-bp108z124a8o7****
ZoneId	string	The zone ID.	cn-hangzhou-h
Category	string	The edition of the cluster. Valid values: Basic: single-replica edition. HighAvailability: double-replica edition.	HighAvailability
Engine	string	The engine type.	ClickHouse
SupportMysqlPort	boolean	Indicates whether the MySQL port is supported. Valid values: true: The MySQL port is supported. false: The MySQL port is not supported.	false
SupportHttpsPort	boolean	Indicates whether the HTTPS port is supported. Valid values: true: The HTTPS port is supported. false: The HTTPS port is not supported.	false
ControlVersion	string	The version of the management and control system. Valid values: v1 v2	v1
PublicIpAddr	string	The IP address of the public endpoint.	121.40.xx.xx
EngineMinorVersion	string	The current minor version.	1.6.0
EngineLatestMinorVersion	string	The latest minor version to which the cluster can be upgraded.	1.34.0
MaintainAutoType	boolean	The upgrade type. false indicates a manual upgrade.	false
ExtStorageType	string	The extended storage type. Valid values: CloudESSD: ESSD PL1 cloud disk. CloudESSD_PL2: ESSD PL2 cloud disk. CloudESSD_PL3: ESSD PL3 cloud disk. CloudEfficiency: ultra disk.	CloudESSD
ExtStorageSize	integer	The extended storage space. Unit: GB.	500
ResourceGroupId	string	The resource group ID.	rg-acfmyf65je6****
ZookeeperClass	string	The Zookeeper specifications.	4 Core 8 GB
AppointmentRestartTime	string	The scheduled restart time. The format is YYYY-MM-DDThh:mm:ssZ (UTC).	2023-11-06T12:00:00Z
ZoneIdVswitchMap	object	The list of vSwitch IDs for the multi-zone instance.	cn-shanghai-f: vsw-zm0n42d5vvuo****
AvailableUpgradeMajorVersion	object	The destination major version to which the cluster can be upgraded.	{"MajorVersion":"MinorVersion"}
AppointmentRestartNodeTime	string	The scheduled time to restart some of the nodes. The format is YYYY-MM-DDThh:mm:ssZ (UTC).	2023-11-06T12:00:00Z
AppointmentRestartNodeList	string	The list of nodes to be restarted at the scheduled time.	ck-k1a976p3n******--clickhouse-s-0-r-0,ck-k1a976p3n****-**-clickhouse-s-0-r-1
AppointmentElectZookeeperTime	string	The scheduled primary-secondary switchover time. The format is YYYY-MM-DDThh:mm:ssZ (UTC).	2023-11-06T12:00:00Z
AppointmentElectZookeeperDisableWrite	boolean	The configuration for the primary-secondary switchover. Valid values: true: Write operations are suspended for the instance during the switchover. false: Write operations are not suspended for the instance during the switchover.	true
VpcIpAddr	string	The IP address of the VPC endpoint.	192.168.xx.xx
VpcCloudInstanceId	string	The VPC resource ID.	vpc-bp10tr8k9qasioaty****
RequestId	string	The request ID.	05321590-BB65-4720-8CB6-8218E041CDD0

Examples

Success response

JSON format

{
  "DBCluster": {
    "VpcId": "vpc-bp10tr8k9qasioaty****",
    "SupportBackup": 1,
    "SupportOss": 1,
    "EncryptionType": "CloudDisk",
    "DBNodeCount": 1,
    "MaintainTime": "00:00Z-01:00Z",
    "CreateTime": "2021-12-13T11:33:11Z",
    "PayType": "Prepaid",
    "Tags": {
      "Tag": [
        {
          "Key": "department",
          "Value": "it"
        }
      ]
    },
    "PublicConnectionString": "cc-bp1199ya710s7****.public.clickhouse.ads.aliyuncs.com",
    "StorageType": "CloudESSD",
    "Port": 8123,
    "LockMode": "Unlock",
    "Bid": "26842",
    "EngineVersion": "21.8.10.19",
    "IsExpired": "false",
    "ScaleOutStatus": {
      "Progress": "0",
      "Ratio": "0MB/60469MB"
    },
    "LbKind": "",
    "DBClusterId": "cc-bp108z124a8o7****",
    "ConnectionString": "cc-bp1qx68m06981****.ads.rds.aliyuncs.com",
    "EncryptionKey": "685f416f-87c9-4554-8d3a-75b6ce25****",
    "DBClusterType": "Common",
    "CommodityCode": "clickhouse_go_public_cn",
    "ExpireTime": "2022-11-11T16:00:00Z",
    "DBNodeStorage": 100,
    "DBNodeClass": "C8",
    "AliUid": "140692647406****",
    "LockReason": "DISK_FULL",
    "RegionId": "cn-hangzhou",
    "PublicPort": "3306",
    "VSwitchId": "vsw-bp1n874li1t5y57wi****",
    "DBClusterStatus": "Running",
    "DBClusterNetworkType": "vpc",
    "DBClusterDescription": "cc-bp108z124a8o7****",
    "ZoneId": "cn-hangzhou-h",
    "Category": "HighAvailability",
    "Engine": "ClickHouse",
    "SupportMysqlPort": false,
    "SupportHttpsPort": false,
    "ControlVersion": "v1",
    "PublicIpAddr": "121.40.xx.xx",
    "EngineMinorVersion": "1.6.0",
    "EngineLatestMinorVersion": "1.34.0",
    "MaintainAutoType": false,
    "ExtStorageType": "CloudESSD",
    "ExtStorageSize": 500,
    "ResourceGroupId": "rg-acfmyf65je6****",
    "ZookeeperClass": "4 Core 8 GB",
    "AppointmentRestartTime": "2023-11-06T12:00:00Z",
    "ZoneIdVswitchMap": {
      "test": "test",
      "test2": 1
    },
    "AvailableUpgradeMajorVersion": {
      "MajorVersion": "MinorVersion"
    },
    "AppointmentRestartNodeTime": "2023-11-06T12:00:00Z",
    "AppointmentRestartNodeList": "ck-k1a976p3n********-****-clickhouse-s-0-r-0,ck-k1a976p3n********-****-clickhouse-s-0-r-1",
    "AppointmentElectZookeeperTime": "2023-11-06T12:00:00Z",
    "AppointmentElectZookeeperDisableWrite": true,
    "VpcIpAddr": "192.168.xx.xx",
    "VpcCloudInstanceId": "vpc-bp10tr8k9qasioaty****"
  },
  "RequestId": "05321590-BB65-4720-8CB6-8218E041CDD0"
}

Error codes

HTTP status code	Error code	Error message	Description
404	InvalidDBCluster.NotFound	The DBClusterId provided does not exist in our records.	The DBClusterId provided does not exist in our records.

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.