Glue / Paginator / GetDatabases

GetDatabases#

class Glue.Paginator.GetDatabases#
paginator = client.get_paginator('get_databases')
paginate(**kwargs)#

Creates an iterator that will paginate through responses from Glue.Client.get_databases().

See also: AWS API Documentation

Request Syntax

response_iterator = paginator.paginate(
    CatalogId='string',
    ResourceShareType='FOREIGN'|'ALL'|'FEDERATED',
    PaginationConfig={
        'MaxItems': 123,
        'PageSize': 123,
        'StartingToken': 'string'
    }
)
Parameters:
  • CatalogId (string) – The ID of the Data Catalog from which to retrieve Databases. If none is provided, the Amazon Web Services account ID is used by default.

  • ResourceShareType (string) –

    Allows you to specify that you want to list the databases shared with your account. The allowable values are FEDERATED, FOREIGN or ALL.

    • If set to FEDERATED, will list the federated databases (referencing an external entity) shared with your account.

    • If set to FOREIGN, will list the databases shared with your account.

    • If set to ALL, will list the databases shared with your account, as well as the databases in yor local account.

  • PaginationConfig (dict) –

    A dictionary that provides parameters to control pagination.

    • MaxItems (integer) –

      The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.

    • PageSize (integer) –

      The size of each page.

    • StartingToken (string) –

      A token to specify where to start paginating. This is the NextToken from a previous response.

Return type:

dict

Returns:

Response Syntax

{
    'DatabaseList': [
        {
            'Name': 'string',
            'Description': 'string',
            'LocationUri': 'string',
            'Parameters': {
                'string': 'string'
            },
            'CreateTime': datetime(2015, 1, 1),
            'CreateTableDefaultPermissions': [
                {
                    'Principal': {
                        'DataLakePrincipalIdentifier': 'string'
                    },
                    'Permissions': [
                        'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS',
                    ]
                },
            ],
            'TargetDatabase': {
                'CatalogId': 'string',
                'DatabaseName': 'string'
            },
            'CatalogId': 'string',
            'FederatedDatabase': {
                'Identifier': 'string',
                'ConnectionName': 'string'
            }
        },
    ],

}

Response Structure

  • (dict) –

    • DatabaseList (list) –

      A list of Database objects from the specified catalog.

      • (dict) –

        The Database object represents a logical grouping of tables that might reside in a Hive metastore or an RDBMS.

        • Name (string) –

          The name of the database. For Hive compatibility, this is folded to lowercase when it is stored.

        • Description (string) –

          A description of the database.

        • LocationUri (string) –

          The location of the database (for example, an HDFS path).

        • Parameters (dict) –

          These key-value pairs define parameters and properties of the database.

          • (string) –

            • (string) –

        • CreateTime (datetime) –

          The time at which the metadata database was created in the catalog.

        • CreateTableDefaultPermissions (list) –

          Creates a set of default permissions on the table for principals. Used by Lake Formation. Not used in the normal course of Glue operations.

          • (dict) –

            Permissions granted to a principal.

            • Principal (dict) –

              The principal who is granted permissions.

              • DataLakePrincipalIdentifier (string) –

                An identifier for the Lake Formation principal.

            • Permissions (list) –

              The permissions that are granted to the principal.

              • (string) –

        • TargetDatabase (dict) –

          A DatabaseIdentifier structure that describes a target database for resource linking.

          • CatalogId (string) –

            The ID of the Data Catalog in which the database resides.

          • DatabaseName (string) –

            The name of the catalog database.

        • CatalogId (string) –

          The ID of the Data Catalog in which the database resides.

        • FederatedDatabase (dict) –

          A FederatedDatabase structure that references an entity outside the Glue Data Catalog.

          • Identifier (string) –

            A unique identifier for the federated database.

          • ConnectionName (string) –

            The name of the connection to the external metastore.