# Amazon Redshift

> Run SQL with the Redshift Data API and read databases, schemas, tables, statements and query results.

App · 11 actions. Web page: https://docs.lodol.com/docs/integrations/amazon-redshift

## Actions

### Batch execute statement

Batch execute statement. Returns the service response.

**Inputs**

- Sqls (`sqls`, list, required): Sqls.
- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Secret arn (`secret_arn`, text): Secretarn.
- Db user (`db_user`, text): Dbuser.
- Database (`database`, text): Database. Leave empty to use the connected database.
- With event (`with_event`, true/false): Withevent.
- Statement name (`statement_name`, text): Statementname.
- Parameters (`parameters`, list): Parameters.
- Workgroup name (`workgroup_name`, text): Workgroupname.
- Client token (`client_token`, text): Clienttoken.
- Result format (`result_format`, text): Resultformat. One of: `JSON`, `CSV`.
- Session keep alive seconds (`session_keep_alive_seconds`, number): Sessionkeepaliveseconds.
- Session id (`session_id`, text): Sessionid.
- Execution mode (`execution_mode`, text): Executionmode. One of: `TRANSACTION`, `AUTO_COMMIT`.
- Wait time seconds (`wait_time_seconds`, number): Waittimeseconds.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "ClusterIdentifier": "example",
    "CreatedAt": "2026-01-01T00:00:00Z",
    "Database": "example",
    "DbGroups": [],
    "DbUser": "example",
    "HasResultSet": false,
    "Id": "example",
    "RedshiftPid": 1,
    "SecretArn": "example",
    "SessionId": "example",
    "Status": "SUBMITTED",
    "WorkgroupName": "example"
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### Cancel statement

Cancel statement. Returns the service response.

**Inputs**

- Id (`id`, text, required): Id.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "Status": false
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### Describe statement

Describe statement. Returns the service response.

**Inputs**

- Id (`id`, text, required): Id.
- Wait time seconds (`wait_time_seconds`, number): Waittimeseconds.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "ClusterIdentifier": "example",
    "CreatedAt": "2026-01-01T00:00:00Z",
    "Database": "example",
    "DbUser": "example",
    "Duration": 1,
    "Error": "example",
    "ExecutionMode": "TRANSACTION",
    "HasResultSet": false,
    "Id": "example",
    "QueryParameters": [],
    "QueryString": "example",
    "RedshiftPid": 1,
    "RedshiftQueryId": 1,
    "RedshiftQueryUuid": "example",
    "ResultFormat": "JSON",
    "ResultRows": 1,
    "ResultSize": 1,
    "SecretArn": "example",
    "SessionId": "example",
    "Status": "SUBMITTED",
    "SubStatements": [],
    "UpdatedAt": "2026-01-01T00:00:00Z",
    "WorkgroupName": "example"
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### Describe table

Describe table. Returns one page; use the next page cursor to continue.

**Inputs**

- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Secret arn (`secret_arn`, text): Secretarn.
- Db user (`db_user`, text): Dbuser.
- Database (`database`, text): Database. Leave empty to use the connected database.
- Connected database (`connected_database`, text): Connecteddatabase.
- Schema (`schema`, text): Schema.
- Table (`table`, text): Table.
- Next page cursor (`next_token`, text): Nexttoken.
- Page size (`max_results`, number): Maxresults.
- Workgroup name (`workgroup_name`, text): Workgroupname.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "ColumnList": [],
    "NextToken": "example",
    "Records": [],
    "TableName": "example"
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### Execute statement

Execute statement. Returns the service response.

**Inputs**

- Sql (`sql`, text, required): Sql.
- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Secret arn (`secret_arn`, text): Secretarn.
- Db user (`db_user`, text): Dbuser.
- Database (`database`, text): Database. Leave empty to use the connected database.
- With event (`with_event`, true/false): Withevent.
- Statement name (`statement_name`, text): Statementname.
- Parameters (`parameters`, list): Parameters.
- Workgroup name (`workgroup_name`, text): Workgroupname.
- Client token (`client_token`, text): Clienttoken.
- Result format (`result_format`, text): Resultformat. One of: `JSON`, `CSV`.
- Session keep alive seconds (`session_keep_alive_seconds`, number): Sessionkeepaliveseconds.
- Session id (`session_id`, text): Sessionid.
- Wait time seconds (`wait_time_seconds`, number): Waittimeseconds.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "ClusterIdentifier": "example",
    "CreatedAt": "2026-01-01T00:00:00Z",
    "Database": "example",
    "DbGroups": [],
    "DbUser": "example",
    "HasResultSet": false,
    "Id": "example",
    "RedshiftPid": 1,
    "SecretArn": "example",
    "SessionId": "example",
    "Status": "SUBMITTED",
    "WorkgroupName": "example"
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### Get statement result

Get statement result. Returns one page; use the next page cursor to continue.

**Inputs**

- Id (`id`, text, required): Id.
- Next page cursor (`next_token`, text): Nexttoken.
- Wait time seconds (`wait_time_seconds`, number): Waittimeseconds.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "ColumnMetadata": [],
    "NextToken": "example",
    "Records": [],
    "TotalNumRows": 1
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### Get statement result v2

Get statement result v2. Returns one page; use the next page cursor to continue.

**Inputs**

- Id (`id`, text, required): Id.
- Next page cursor (`next_token`, text): Nexttoken.
- Wait time seconds (`wait_time_seconds`, number): Waittimeseconds.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "ColumnMetadata": [],
    "NextToken": "example",
    "Records": [],
    "ResultFormat": "JSON",
    "TotalNumRows": 1
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### List databases

List databases. Returns one page; use the next page cursor to continue.

**Inputs**

- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Database (`database`, text): Database. Leave empty to use the connected database.
- Secret arn (`secret_arn`, text): Secretarn.
- Db user (`db_user`, text): Dbuser.
- Next page cursor (`next_token`, text): Nexttoken.
- Page size (`max_results`, number): Maxresults.
- Workgroup name (`workgroup_name`, text): Workgroupname.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "Databases": [],
    "NextToken": "example"
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### List schemas

List schemas. Returns one page; use the next page cursor to continue.

**Inputs**

- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Secret arn (`secret_arn`, text): Secretarn.
- Db user (`db_user`, text): Dbuser.
- Database (`database`, text): Database. Leave empty to use the connected database.
- Connected database (`connected_database`, text): Connecteddatabase.
- Schema pattern (`schema_pattern`, text): Schemapattern.
- Next page cursor (`next_token`, text): Nexttoken.
- Page size (`max_results`, number): Maxresults.
- Workgroup name (`workgroup_name`, text): Workgroupname.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "NextToken": "example",
    "Schemas": []
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### List statements

List statements. Returns one page; use the next page cursor to continue.

**Inputs**

- Next page cursor (`next_token`, text): Nexttoken.
- Page size (`max_results`, number): Maxresults.
- Statement name (`statement_name`, text): Statementname.
- Status (`status`, text): Status. One of: `SUBMITTED`, `PICKED`, `STARTED`, `FINISHED`, `ABORTED`, `FAILED`, `ALL`.
- Role level (`role_level`, true/false): Rolelevel.
- Database (`database`, text): Database. Leave empty to use the connected database.
- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Workgroup name (`workgroup_name`, text): Workgroupname.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "NextToken": "example",
    "Statements": []
  },
  "has_more": false,
  "next_cursor": "example"
}
```

### List tables

List tables. Returns one page; use the next page cursor to continue.

**Inputs**

- Cluster identifier (`cluster_identifier`, text): Clusteridentifier.
- Secret arn (`secret_arn`, text): Secretarn.
- Db user (`db_user`, text): Dbuser.
- Database (`database`, text): Database. Leave empty to use the connected database.
- Connected database (`connected_database`, text): Connecteddatabase.
- Schema pattern (`schema_pattern`, text): Schemapattern.
- Table pattern (`table_pattern`, text): Tablepattern.
- Next page cursor (`next_token`, text): Nexttoken.
- Page size (`max_results`, number): Maxresults.
- Workgroup name (`workgroup_name`, text): Workgroupname.

**Outputs**

- `data` (object): The complete service response.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Pass this value to the next page cursor.

**Example output**

```json
{
  "data": {
    "NextToken": "example",
    "Tables": []
  },
  "has_more": false,
  "next_cursor": "example"
}
```
