Skip to content

RedshiftDataAPIServiceClient#

Index > RedshiftDataAPIService > RedshiftDataAPIServiceClient

Auto-generated documentation for RedshiftDataAPIService type annotations stubs module mypy-boto3-redshift-data.

RedshiftDataAPIServiceClient#

Type annotations and code completion for boto3.client("redshift-data"). boto3 documentation

# RedshiftDataAPIServiceClient usage example

from boto3.session import Session
from mypy_boto3_redshift_data.client import RedshiftDataAPIServiceClient

def get_redshift-data_client() -> RedshiftDataAPIServiceClient:
    return Session().client("redshift-data")

Exceptions#

boto3 client exceptions are generated in runtime. This class provides code completion for boto3.client("redshift-data").exceptions structure.

# Exceptions.exceptions usage example

client = boto3.client("redshift-data")

try:
    do_something(client)
except (
    client.exceptions.ActiveSessionsExceededException,
    client.exceptions.ActiveStatementsExceededException,
    client.exceptions.BatchExecuteStatementException,
    client.exceptions.ClientError,
    client.exceptions.DatabaseConnectionException,
    client.exceptions.ExecuteStatementException,
    client.exceptions.InternalServerException,
    client.exceptions.QueryTimeoutException,
    client.exceptions.ResourceNotFoundException,
    client.exceptions.ValidationException,
) as e:
    print(e)
# Exceptions.exceptions type checking example

from mypy_boto3_redshift_data.client import Exceptions

def handle_error(exc: Exceptions.ActiveSessionsExceededException) -> None:
    ...

Methods#

batch_execute_statement#

Runs one or more SQL statements, which can be data manipulation language (DML) or data definition language (DDL).

Type annotations and code completion for boto3.client("redshift-data").batch_execute_statement method. boto3 documentation

# batch_execute_statement method definition

def batch_execute_statement(
    self,
    *,
    Sqls: Sequence[str],
    ClientToken: str = ...,
    ClusterIdentifier: str = ...,
    Database: str = ...,
    DbUser: str = ...,
    ResultFormat: ResultFormatStringType = ...,  # (1)
    SecretArn: str = ...,
    SessionId: str = ...,
    SessionKeepAliveSeconds: int = ...,
    StatementName: str = ...,
    WithEvent: bool = ...,
    WorkgroupName: str = ...,
) -> BatchExecuteStatementOutputTypeDef:  # (2)
    ...
  1. See ResultFormatStringType
  2. See BatchExecuteStatementOutputTypeDef
# batch_execute_statement method usage example with argument unpacking

kwargs: BatchExecuteStatementInputRequestTypeDef = {  # (1)
    "Sqls": ...,
}

parent.batch_execute_statement(**kwargs)
  1. See BatchExecuteStatementInputRequestTypeDef

can_paginate#

Check if an operation can be paginated.

Type annotations and code completion for boto3.client("redshift-data").can_paginate method. boto3 documentation

# can_paginate method definition

def can_paginate(
    self,
    operation_name: str,
) -> bool:
    ...

cancel_statement#

Cancels a running query.

Type annotations and code completion for boto3.client("redshift-data").cancel_statement method. boto3 documentation

# cancel_statement method definition

def cancel_statement(
    self,
    *,
    Id: str,
) -> CancelStatementResponseTypeDef:  # (1)
    ...
  1. See CancelStatementResponseTypeDef
# cancel_statement method usage example with argument unpacking

kwargs: CancelStatementRequestRequestTypeDef = {  # (1)
    "Id": ...,
}

parent.cancel_statement(**kwargs)
  1. See CancelStatementRequestRequestTypeDef

close#

Closes underlying endpoint connections.

Type annotations and code completion for boto3.client("redshift-data").close method. boto3 documentation

# close method definition

def close(
    self,
) -> None:
    ...

describe_statement#

Describes the details about a specific instance when a query was run by the Amazon Redshift Data API.

Type annotations and code completion for boto3.client("redshift-data").describe_statement method. boto3 documentation

# describe_statement method definition

def describe_statement(
    self,
    *,
    Id: str,
) -> DescribeStatementResponseTypeDef:  # (1)
    ...
  1. See DescribeStatementResponseTypeDef
# describe_statement method usage example with argument unpacking

kwargs: DescribeStatementRequestRequestTypeDef = {  # (1)
    "Id": ...,
}

parent.describe_statement(**kwargs)
  1. See DescribeStatementRequestRequestTypeDef

describe_table#

Describes the detailed information about a table from metadata in the cluster.

Type annotations and code completion for boto3.client("redshift-data").describe_table method. boto3 documentation

# describe_table method definition

def describe_table(
    self,
    *,
    Database: str,
    ClusterIdentifier: str = ...,
    ConnectedDatabase: str = ...,
    DbUser: str = ...,
    MaxResults: int = ...,
    NextToken: str = ...,
    Schema: str = ...,
    SecretArn: str = ...,
    Table: str = ...,
    WorkgroupName: str = ...,
) -> DescribeTableResponseTypeDef:  # (1)
    ...
  1. See DescribeTableResponseTypeDef
# describe_table method usage example with argument unpacking

kwargs: DescribeTableRequestRequestTypeDef = {  # (1)
    "Database": ...,
}

parent.describe_table(**kwargs)
  1. See DescribeTableRequestRequestTypeDef

execute_statement#

Runs an SQL statement, which can be data manipulation language (DML) or data definition language (DDL).

Type annotations and code completion for boto3.client("redshift-data").execute_statement method. boto3 documentation

# execute_statement method definition

def execute_statement(
    self,
    *,
    Sql: str,
    ClientToken: str = ...,
    ClusterIdentifier: str = ...,
    Database: str = ...,
    DbUser: str = ...,
    Parameters: Sequence[SqlParameterTypeDef] = ...,  # (1)
    ResultFormat: ResultFormatStringType = ...,  # (2)
    SecretArn: str = ...,
    SessionId: str = ...,
    SessionKeepAliveSeconds: int = ...,
    StatementName: str = ...,
    WithEvent: bool = ...,
    WorkgroupName: str = ...,
) -> ExecuteStatementOutputTypeDef:  # (3)
    ...
  1. See SqlParameterTypeDef
  2. See ResultFormatStringType
  3. See ExecuteStatementOutputTypeDef
# execute_statement method usage example with argument unpacking

kwargs: ExecuteStatementInputRequestTypeDef = {  # (1)
    "Sql": ...,
}

parent.execute_statement(**kwargs)
  1. See ExecuteStatementInputRequestTypeDef

generate_presigned_url#

Generate a presigned url given a client, its method, and arguments.

Type annotations and code completion for boto3.client("redshift-data").generate_presigned_url method. boto3 documentation

# generate_presigned_url method definition

def generate_presigned_url(
    self,
    ClientMethod: str,
    Params: Mapping[str, Any] = ...,
    ExpiresIn: int = 3600,
    HttpMethod: str = ...,
) -> str:
    ...

get_statement_result#

Fetches the temporarily cached result of an SQL statement in JSON format.

Type annotations and code completion for boto3.client("redshift-data").get_statement_result method. boto3 documentation

# get_statement_result method definition

def get_statement_result(
    self,
    *,
    Id: str,
    NextToken: str = ...,
) -> GetStatementResultResponseTypeDef:  # (1)
    ...
  1. See GetStatementResultResponseTypeDef
# get_statement_result method usage example with argument unpacking

kwargs: GetStatementResultRequestRequestTypeDef = {  # (1)
    "Id": ...,
}

parent.get_statement_result(**kwargs)
  1. See GetStatementResultRequestRequestTypeDef

get_statement_result_v2#

Fetches the temporarily cached result of an SQL statement in CSV format.

Type annotations and code completion for boto3.client("redshift-data").get_statement_result_v2 method. boto3 documentation

# get_statement_result_v2 method definition

def get_statement_result_v2(
    self,
    *,
    Id: str,
    NextToken: str = ...,
) -> GetStatementResultV2ResponseTypeDef:  # (1)
    ...
  1. See GetStatementResultV2ResponseTypeDef
# get_statement_result_v2 method usage example with argument unpacking

kwargs: GetStatementResultV2RequestRequestTypeDef = {  # (1)
    "Id": ...,
}

parent.get_statement_result_v2(**kwargs)
  1. See GetStatementResultV2RequestRequestTypeDef

list_databases#

List the databases in a cluster.

Type annotations and code completion for boto3.client("redshift-data").list_databases method. boto3 documentation

# list_databases method definition

def list_databases(
    self,
    *,
    Database: str,
    ClusterIdentifier: str = ...,
    DbUser: str = ...,
    MaxResults: int = ...,
    NextToken: str = ...,
    SecretArn: str = ...,
    WorkgroupName: str = ...,
) -> ListDatabasesResponseTypeDef:  # (1)
    ...
  1. See ListDatabasesResponseTypeDef
# list_databases method usage example with argument unpacking

kwargs: ListDatabasesRequestRequestTypeDef = {  # (1)
    "Database": ...,
}

parent.list_databases(**kwargs)
  1. See ListDatabasesRequestRequestTypeDef

list_schemas#

Lists the schemas in a database.

Type annotations and code completion for boto3.client("redshift-data").list_schemas method. boto3 documentation

# list_schemas method definition

def list_schemas(
    self,
    *,
    Database: str,
    ClusterIdentifier: str = ...,
    ConnectedDatabase: str = ...,
    DbUser: str = ...,
    MaxResults: int = ...,
    NextToken: str = ...,
    SchemaPattern: str = ...,
    SecretArn: str = ...,
    WorkgroupName: str = ...,
) -> ListSchemasResponseTypeDef:  # (1)
    ...
  1. See ListSchemasResponseTypeDef
# list_schemas method usage example with argument unpacking

kwargs: ListSchemasRequestRequestTypeDef = {  # (1)
    "Database": ...,
}

parent.list_schemas(**kwargs)
  1. See ListSchemasRequestRequestTypeDef

list_statements#

List of SQL statements.

Type annotations and code completion for boto3.client("redshift-data").list_statements method. boto3 documentation

# list_statements method definition

def list_statements(
    self,
    *,
    MaxResults: int = ...,
    NextToken: str = ...,
    RoleLevel: bool = ...,
    StatementName: str = ...,
    Status: StatusStringType = ...,  # (1)
) -> ListStatementsResponseTypeDef:  # (2)
    ...
  1. See StatusStringType
  2. See ListStatementsResponseTypeDef
# list_statements method usage example with argument unpacking

kwargs: ListStatementsRequestRequestTypeDef = {  # (1)
    "MaxResults": ...,
}

parent.list_statements(**kwargs)
  1. See ListStatementsRequestRequestTypeDef

list_tables#

List the tables in a database.

Type annotations and code completion for boto3.client("redshift-data").list_tables method. boto3 documentation

# list_tables method definition

def list_tables(
    self,
    *,
    Database: str,
    ClusterIdentifier: str = ...,
    ConnectedDatabase: str = ...,
    DbUser: str = ...,
    MaxResults: int = ...,
    NextToken: str = ...,
    SchemaPattern: str = ...,
    SecretArn: str = ...,
    TablePattern: str = ...,
    WorkgroupName: str = ...,
) -> ListTablesResponseTypeDef:  # (1)
    ...
  1. See ListTablesResponseTypeDef
# list_tables method usage example with argument unpacking

kwargs: ListTablesRequestRequestTypeDef = {  # (1)
    "Database": ...,
}

parent.list_tables(**kwargs)
  1. See ListTablesRequestRequestTypeDef

get_paginator#

Type annotations and code completion for boto3.client("redshift-data").get_paginator method with overloads.