scheduled_query_histories

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

Overview

Name	scheduled_query_histories
Type	Resource
Id	aws.logs.scheduled_query_histories

Fields

The following fields are returned by SELECT queries:

get_scheduled_query_history

Name	Datatype	Description
destinations	array	Information about destination processing for this query execution.
error_message	string	Error message if the query execution failed.
execution_status	string	The execution status of the scheduled query run. (Running, InvalidQuery, Complete, Failed, Timeout)
query_id	string	The unique identifier for this query execution.
triggered_timestamp	integer (int64)	The timestamp when the scheduled query execution was triggered.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_scheduled_query_history	select	region		Retrieves the execution history of a scheduled query within a specified time range, including query results and destination processing status.

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_scheduled_query_history

Retrieves the execution history of a scheduled query within a specified time range, including query results and destination processing status.

SELECT
destinations,
error_message,
execution_status,
query_id,
triggered_timestamp
FROM aws.logs.scheduled_query_histories
WHERE region = '{{ region }}' -- required
;