statement_results

Creates, updates, deletes, gets or lists a statement_results resource.

Overview

Name	statement_results
Type	Resource
Id	aws.redshift_data.statement_results

Fields

The following fields are returned by SELECT queries:

get_statement_result

Name	Datatype	Description
record	array	The results of the SQL statement in JSON format.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_statement_result	select	region		Fetches the temporarily cached result of an SQL statement in JSON format. The ExecuteStatement or BatchExecuteStatement operation that ran the SQL statement must have specified ResultFormat as JSON , or let the format default to JSON. A token is returned to page through the statement results. For more information about the Amazon Redshift Data API and CLI usage examples, see Using the Amazon Redshift Data API in the Amazon Redshift Management Guide.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_statement_result

Fetches the temporarily cached result of an SQL statement in JSON format. The ExecuteStatement or BatchExecuteStatement operation that ran the SQL statement must have specified ResultFormat as JSON , or let the format default to JSON. A token is returned to page through the statement results. For more information about the Amazon Redshift Data API and CLI usage examples, see Using the Amazon Redshift Data API in the Amazon Redshift Management Guide.

SELECT
record
FROM aws.redshift_data.statement_results
WHERE region = '{{ region }}' -- required
;