DescribeAllDataSource - ApsaraDB for ClickHouse - Alibaba Cloud Documentation Center

Queries a list of databases, tables, and columns in an ApsaraDB for ClickHouse cluster.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer.

Debug

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

Parameter	Type	Required	Description	Example
DBClusterId	string	Yes	The cluster ID.	cc-bp108z124a8o7****
SchemaName	string	Yes	The database name.	database
TableName	string	Yes	The table name.	table

Response parameters

Parameter	Type	Description	Example
	object
RequestId	string	The request ID.	05321590-BB65-4720-8CB6-8218E041CDD0
Tables	array<object>	The information about the tables.
	object
TableName	string	The table name.	table
DBClusterId	string	The cluster ID.	cc-bp108z124a8o7****
SchemaName	string	The database name.	database
Columns	array<object>	The information about the columns.
	object
Type	string	The type of the column.	String
ColumnName	string	The column name.	name
TableName	string	The table name.	table
AutoIncrementColumn	boolean	Indicates whether the column is an auto-increment column. Valid values: true false	true
DBClusterId	string	The cluster ID.	cc-bp108z124a8o7****
PrimaryKey	boolean	Indicates whether the column is the primary key of the table. Valid values: true false	true
SchemaName	string	The database name.	database
Schemas	array<object>	The information about the databases.
	object
DBClusterId	string	The cluster ID.	cc-bp108z124a8o7****
SchemaName	string	The database name.	database

Examples

Sample success responses

JSONformat

{
  "RequestId": "05321590-BB65-4720-8CB6-8218E041CDD0",
  "Tables": {
    "Table": [
      {
        "TableName": "table",
        "DBClusterId": "cc-bp108z124a8o7****",
        "SchemaName": "database"
      }
    ]
  },
  "Columns": {
    "Column": [
      {
        "Type": "String",
        "ColumnName": "name",
        "TableName": "table",
        "AutoIncrementColumn": true,
        "DBClusterId": "cc-bp108z124a8o7****",
        "PrimaryKey": true,
        "SchemaName": "database"
      }
    ]
  },
  "Schemas": {
    "Schema": [
      {
        "DBClusterId": "cc-bp108z124a8o7****",
        "SchemaName": "database"
      }
    ]
  }
}

Error codes

HTTP status code	Error code	Error message	Description
500	InternalError	An error occurred while processing your request.	An error occurred while processing your request.
503	ServiceUnavailable	An error occurred while processing your request.	An error occurred while processing your request.

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation

No change history