Redshift Data List Statements - BlinkOps Documentation

List the SQL statements that were run through the Redshift Data API, newest first, with each statement’s Id, status and query text. Use it to find the Id of an earlier statement, to check what a workflow ran, or to poll for statements that have finished. Results are paginated. When the response contains a NextToken, run the action again with that value in Next Token to fetch the next page.

External DocumentationTo learn more, visit the AWS documentation.

Basic Parameters

Parameter	Description
AWS Region	The AWS Region of the Redshift cluster or Serverless workgroup.
Cluster Identifier	The provisioned cluster to list statements for. Cannot be combined with `Workgroup Name`.
Database	The database to list statements for. Can be obtained using the `Redshift Data List Databases` action.
Include All Statements For The Role	Select to list every statement run by the caller’s IAM role. When cleared, only the statements run by that role in the current IAM session are listed. Selected by default.
Max Results	The maximum number of statements to return in a single response. Valid values range from `0` to `100`.
Next Token	The pagination token for fetching the next page of records, taken from the `NextToken` field of a previous response. Leave empty to fetch the first page.
Statement Name	The statement name prefix to match. The match is case-sensitive, so a value of `myStatement` returns `myStatement1`, `myStatement2` and so on.
Status	Select the state that a statement must be in to appear in the results.
Workgroup Name	The Redshift Serverless workgroup to list statements for. Cannot be combined with `Cluster Identifier`.

Advanced Parameters

Parameter	Description
Disable XML To JSON Auto Convert	When checked, XML responses are not automatically converted into JSON format.

Example Output

{
	"NextToken": "",
	"Statements": [
		{
			"CreatedAt": 1598323175.823,
			"Id": "d9b6c0c9-0747-4bf4-b142-e8883122f766",
			"IsBatchStatement": false,
			"QueryString": "select * from users limit 10",
			"ResultFormat": "CSV",
			"SecretArn": "arn:aws:secretsmanager:us-east-1:123456789012:secret:redshift-1",
			"SessionId": "1e2f3a4b-5c6d-7e8f-9a0b-1c2d3e4f5a6b",
			"StatementName": "list-users",
			"Status": "FINISHED",
			"UpdatedAt": 1598323179.774
		}
	]
}

Workflow Library Example

Redshift Data List Statements with Aws and Send Results Via Email

Preview this Workflow on desktop

​Basic Parameters

​Advanced Parameters

​Example Output

​Workflow Library Example

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example