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

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.

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

try:
    do_something(client)
except (
    client.ActiveStatementsExceededException,
    client.BatchExecuteStatementException,
    client.ClientError,
    client.DatabaseConnectionException,
    client.ExecuteStatementException,
    client.InternalServerException,
    client.ResourceNotFoundException,
    client.ValidationException,
) as e:
    print(e)
Type checking example
from mypy_boto3_redshift_data.client import Exceptions

def handle_error(exc: Exceptions.ActiveStatementsExceededException) -> 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

Method definition
def batch_execute_statement(
    self,
    *,
    Database: str,
    Sqls: Sequence[str],
    ClientToken: str = ...,
    ClusterIdentifier: str = ...,
    DbUser: str = ...,
    SecretArn: str = ...,
    StatementName: str = ...,
    WithEvent: bool = ...,
    WorkgroupName: str = ...,
) -> BatchExecuteStatementOutputTypeDef:  # (1)
    ...
  1. See BatchExecuteStatementOutputTypeDef
Usage example with kwargs
kwargs: BatchExecuteStatementInputRequestTypeDef = {  # (1)
    "Database": ...,
    "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

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

Method definition
def cancel_statement(
    self,
    *,
    Id: str,
) -> CancelStatementResponseTypeDef:  # (1)
    ...
  1. See CancelStatementResponseTypeDef
Usage example with kwargs
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

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

Method definition
def describe_statement(
    self,
    *,
    Id: str,
) -> DescribeStatementResponseTypeDef:  # (1)
    ...
  1. See DescribeStatementResponseTypeDef
Usage example with kwargs
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

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
Usage example with kwargs
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

Method definition
def execute_statement(
    self,
    *,
    Database: str,
    Sql: str,
    ClientToken: str = ...,
    ClusterIdentifier: str = ...,
    DbUser: str = ...,
    Parameters: Sequence[SqlParameterTypeDef] = ...,  # (1)
    SecretArn: str = ...,
    StatementName: str = ...,
    WithEvent: bool = ...,
    WorkgroupName: str = ...,
) -> ExecuteStatementOutputTypeDef:  # (2)
    ...
  1. See SqlParameterTypeDef
  2. See ExecuteStatementOutputTypeDef
Usage example with kwargs
kwargs: ExecuteStatementInputRequestTypeDef = {  # (1)
    "Database": ...,
    "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

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.

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

Method definition
def get_statement_result(
    self,
    *,
    Id: str,
    NextToken: str = ...,
) -> GetStatementResultResponseTypeDef:  # (1)
    ...
  1. See GetStatementResultResponseTypeDef
Usage example with kwargs
kwargs: GetStatementResultRequestRequestTypeDef = {  # (1)
    "Id": ...,
}

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

list_databases

List the databases in a cluster.

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

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
Usage example with kwargs
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

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
Usage example with kwargs
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

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
Usage example with kwargs
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

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
Usage example with kwargs
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.