All Products
Search
Document Center

Data Lake Formation:ListDatabases

Last Updated:Dec 11, 2025

Retrieves a paginated list of databases in a data lake. You can match databases by name.

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

dlf:ListDatabases

list

*All Resource

*

None None

Request syntax

GET /api/metastore/catalogs/databases/list HTTP/1.1

Request parameters

Parameter

Type

Required

Description

Example

CatalogId

string

No

The namespace for database categorization. By default, this is the UID of the Alibaba Cloud account.

1344371

NamePattern

string

No

A regular expression that matches database names. To match all databases, enter .*.

.*

NextPageToken

string

No

The token to retrieve the next page of results. This is returned in the response. For the first page, pass an empty string ("").

2cb472ec1bf84f8d92f9c4baa0d21c19aa!

PageSize

integer

No

The number of entries to return on each page.

10

  • NamePattern: The name pattern of the databases to query. Wildcard matching is supported. A period (.) matches a single character, and an asterisk (*) matches any number of characters.

  • NextPageToken: The token used for pagination. Leave this parameter empty for the first request. For subsequent requests, set this parameter to the NextPageToken value from the previous response. An empty string returned for this parameter indicates that all results have been retrieved.

  • PageSize: The number of entries to return in a single response.

Response elements

Element

Type

Description

Example

object

The response body.

Code

string

The status of the request.

OK

Databases

array

The list of metadatabases.

[{"name":"test"}]

Database

The query result for the metadatabase.

Message

string

The error message.

.

NextPageToken

string

The token for the next page of results.

2cb472ec1bf84f8d92f9c4baa0d21c19aa

RequestId

string

The request ID.

558D764F-8C55-49CA-BF38-80EA532FC08F

Success

boolean

Indicates whether the request was successful.

true

Description of error codes for the Code parameter
InternalError: An internal error occurred. For more information, see the Message parameter.

Examples

Success response

JSON format

{
  "Code": "OK",
  "Databases": [
    {
      "CreateTime": 1608707407,
      "Description": "this is a hive database",
      "LocationUri": "/hdfs/hivedb/data",
      "Name": "database_test",
      "OwnerName": "zhangsan",
      "OwnerType": "USER",
      "Parameters": {
        "key": "key"
      },
      "Privileges": {
        "GroupPrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        },
        "RolePrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        },
        "UserPrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        }
      },
      "UpdateTime": 1608707407,
      "CreatedBy": "root"
    }
  ],
  "Message": ".",
  "NextPageToken": "2cb472ec1bf84f8d92f9c4baa0d21c19aa",
  "RequestId": "558D764F-8C55-49CA-BF38-80EA532FC08F",
  "Success": true
}

Error codes

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.