Statement Result

redshift_data.get_statement_result
ActionAmazon Web Servicesconnection required

Calls the AWS redshift_data API (SigV4).

Read a finished statement's rows.

Connection

Required
Yes — the node will not save without one
Auth type
API key
Providers
Amazon Redshift Data API
Secret shape
{"access_key_id", "secret_access_key"}
Config it needs
region
Resolved by
config.connection_id, else node.connection_id

Configuration

3 fields, 1 required. A dotted path is a nested object and name[] an array of objects — the editor renders the same tree.

FieldTypeRequiredDefaultConstraintsExample
region
AWS region (overrides the connection).
stringNo———
statement_id
Id from execute_statement.
stringYes———
next_token
Continues a previous run of this node, using that run's next_token output.
stringNo———

Output

One shape.

result

FieldTypeExample
columns
array—
rows
array—
count
Rows on this page — compare with result_rows.
number—
next_token
Cursor for the next page; empty when there are no further pages.
string—
{
  "columns": [],
  "count": 0,
  "next_token": "",
  "rows": []
}

Related Amazon Redshift Data API nodes

See Statement Result run in a workflow.

In a technical demo we add the Amazon Redshift Data API connection, drop the node on the canvas and let Workflow Health pre-flight it before the first real run.