Athena / Paginator / GetQueryResults

GetQueryResults

class Athena.Paginator.GetQueryResults

paginator = client.get_paginator('get_query_results')

paginate(**kwargs)

Creates an iterator that will paginate through responses from Athena.Client.get_query_results().

See also: AWS API Documentation

Request Syntax

response_iterator = paginator.paginate(
    QueryExecutionId='string',
    PaginationConfig={
        'MaxItems': 123,
        'PageSize': 123,
        'StartingToken': 'string'
    }
)

Parameters:

• QueryExecutionId (string) –

  [REQUIRED]

  The unique ID of the query execution.

• 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

{
    'UpdateCount': 123,
    'ResultSet': {
        'Rows': [
            {
                'Data': [
                    {
                        'VarCharValue': 'string'
                    },
                ]
            },
        ],
        'ResultSetMetadata': {
            'ColumnInfo': [
                {
                    'CatalogName': 'string',
                    'SchemaName': 'string',
                    'TableName': 'string',
                    'Name': 'string',
                    'Label': 'string',
                    'Type': 'string',
                    'Precision': 123,
                    'Scale': 123,
                    'Nullable': 'NOT_NULL'|'NULLABLE'|'UNKNOWN',
                    'CaseSensitive': True|False
                },
            ]
        }
    },

}

Response Structure

• (dict) –

  • UpdateCount (integer) –

    The number of rows inserted with a CREATE TABLE AS SELECT statement.

  • ResultSet (dict) –

    The results of the query execution.

    • Rows (list) –

      The rows in the table.

      • (dict) –

        The rows that make up a query result table.

        • Data (list) –

          The data that populates a row in a query result table.

          • (dict) –

            A piece of data (a field in the table).

            • VarCharValue (string) –

              The value of the datum.

    • ResultSetMetadata (dict) –

      The metadata that describes the column structure and data types of a table of query results.

      • ColumnInfo (list) –

        Information about the columns returned in a query result metadata.

        • (dict) –

          Information about the columns in a query execution result.

          • CatalogName (string) –

            The catalog to which the query results belong.

          • SchemaName (string) –

            The schema name (database name) to which the query results belong.

          • TableName (string) –

            The table name for the query results.

          • Name (string) –

            The name of the column.

          • Label (string) –

            A column label.

          • Type (string) –

            The data type of the column.

          • Precision (integer) –

            For DECIMAL data types, specifies the total number of digits, up to 38. For performance reasons, we recommend up to 18 digits.

          • Scale (integer) –

            For DECIMAL data types, specifies the total number of digits in the fractional part of the value. Defaults to 0.

          • Nullable (string) –

            Unsupported constraint. This value always shows as UNKNOWN.

          • CaseSensitive (boolean) –

            Indicates whether values in the column are case-sensitive.