steampipe plugin install awssteampipe plugin install aws

Table: aws_sfn_state_machine_execution_history

A state machine execution occurs when an AWS Step Functions state machine runs and performs its tasks. Each Step Functions state machine can have multiple simultaneous executions. Each execution event is stored in history. AWS Step Functions has a hard quota of 25,000 entries in the execution history.

Examples

Basic info

select
  id,
  execution_arn,
  previous_event_id,
  timestamp,
  type
from
  aws_sfn_state_machine_execution_history;

List execution started event details

select
  id,
  execution_arn,
  execution_started_event_details -> 'Input' as event_input,
  execution_started_event_details -> 'InputDetails' as event_input_details,
  execution_started_event_details ->> 'RoleArn' as event_role_arn
from
  aws_sfn_state_machine_execution_history
where
  type = 'ExecutionStarted';

.inspect aws_sfn_state_machine_execution_history

AWS Step Functions State Machine Execution History

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
activity_failed_event_details	jsonb	Contains details about an activity that failed during an execution.
activity_schedule_failed_event_details	jsonb	Contains details about an activity schedule event that failed during an execution.
activity_scheduled_event_details	jsonb	Contains details about an activity scheduled during an execution.
activity_started_event_details	jsonb	Contains details about the start of an activity during an execution.
activity_succeeded_event_details	jsonb	Contains details about an activity that successfully terminated during an execution.
activity_timed_out_event_details	jsonb	Contains details about an activity timeout that occurred during an execution.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
execution_aborted_event_details	jsonb	Contains details about an abort of an execution.
execution_arn	text	The Amazon Resource Name (ARN) that identifies the execution.
execution_failed_event_details	jsonb	Contains details about an execution failure event.
execution_started_event_details	jsonb	Contains details about the start of the execution.
execution_succeeded_event_details	jsonb	Contains details about the successful termination of the execution.
execution_timed_out_event_details	jsonb	Contains details about the execution timeout that occurred during the execution.
id	text	The id of the event.
lambda_function_failed_event_details	jsonb	Contains details about a lambda function that failed during an execution.
lambda_function_schedule_failed_event_details	jsonb	Contains details about a failed lambda function schedule event that occurred during an execution.
lambda_function_scheduled_event_details	jsonb	Contains details about a lambda function scheduled during an execution.
lambda_function_start_failed_event_details	jsonb	Contains details about a lambda function that failed to start during an execution.
lambda_function_succeeded_event_details	jsonb	Contains details about a lambda function that terminated successfully during an execution.
lambda_function_timed_out_event_details	jsonb	Contains details about a lambda function timeout that occurred during an execution.
map_iteration_aborted_event_details	jsonb	Contains details about an iteration of a Map state that was aborted.
map_iteration_failed_event_details	jsonb	Contains details about an iteration of a Map state that failed.
map_iteration_started_event_details	jsonb	Contains details about an iteration of a Map state that was started.
map_iteration_succeeded_event_details	jsonb	Contains details about an iteration of a Map state that succeeded.
map_state_started_event_details	jsonb	Contains details about Map state that was started.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
previous_event_id	text	The id of the previous event.
region	text	The AWS Region in which the resource is located.
state_entered_event_details	jsonb	Contains details about a state entered during an execution.
state_exited_event_details	jsonb	Contains details about an exit from a state during an execution.
task_failed_event_details	jsonb	Contains details about the failure of a task.
task_scheduled_event_details	jsonb	Contains details about a task that was scheduled.
task_start_failed_event_details	jsonb	Contains details about a task that failed to start.
task_started_event_details	jsonb	Contains details about a task that was started.
task_submit_failed_event_details	jsonb	Contains details about a task that where the submit failed.
task_submitted_event_details	jsonb	Contains details about a submitted task.
task_succeeded_event_details	jsonb	Contains details about a task that succeeded.
task_timed_out_event_details	jsonb	Contains details about a task that timed out.
timestamp	timestamp with time zone	The date and time the event occurred.
title	text	Title of the resource.
type	text	The type of the event.

turbot/aws

Table: aws_sfn_state_machine_execution_history

Examples

Basic info

List execution started event details

.inspect aws_sfn_state_machine_execution_history

Steampipe

Resources

Community