steampipe plugin install awssteampipe plugin install aws

Table: aws_cloudformation_stack

A stack is a collection of AWS resources that you can manage as a single unit.

Examples

Find the status of each cloudformation stack

select
  name,
  id,
  status
from
  aws_cloudformation_stack;

List of cloudformation stack where rollback is disabled

select
  name,
  disable_rollback
from
  aws_cloudformation_stack
where
  disable_rollback;

List of stacks where termination protection is not enabled

select
  name,
  enable_termination_protection
from
  aws_cloudformation_stack
where
  not enable_termination_protection;

Rollback configuration info for each cloudformation stack

select
  name,
  rollback_configuration ->> 'MonitoringTimeInMinutes' as monitoring_time_in_min,
  rollback_configuration ->> 'RollbackTriggers' as rollback_triggers
from
  aws_cloudformation_stack;

Resource ARNs where notifications about stack actions will be sent

select
  name,
  jsonb_array_elements_text(notification_arns) as resource_arns
from
  aws_cloudformation_stack;

Query examples

.inspect aws_cloudformation_stack

AWS CloudFormation Stack

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.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
capabilities	jsonb	The capabilities allowed in the stack.
creation_time	timestamp with time zone	The time at which the stack was created.
description	text	A user-defined description associated with the stack.
disable_rollback	boolean	Boolean to enable or disable rollback on stack creation failures.
enable_termination_protection	boolean	Specifies whether termination protection is enabled for the stack.
id	text	Unique identifier of the stack.
last_updated_time	timestamp with time zone	The time the stack was last updated. This field will only be returned if the stack has been updated at least once.
name	text	The name associated with the stack.
notification_arns	jsonb	SNS topic ARNs to which stack related events are published.
outputs	jsonb	A list of output structures.
parameters	jsonb	A list of Parameter structures.
parent_id	text	ID of the direct parent of this stack.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
resources	jsonb	A list of Stack resource structures.
role_arn	text	The Amazon Resource Name (ARN) of an AWS Identity and Access Management (IAM) role that is associated with the stack.
rollback_configuration	jsonb	The rollback triggers for AWS CloudFormation to monitor during stack creation and updating operations, and for the specified monitoring period afterwards.
root_id	text	ID of the top-level stack to which the nested stack ultimately belongs.
stack_drift_status	text	Status of the stack's actual configuration compared to its expected template configuration.
status	text	Current status of the stack.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags associated with stack.
template_body	text	Structure containing the template body.
template_body_json	jsonb	Structure containing the template body. Parsed into json object for better readability.
title	text	Title of the resource.

turbot/aws

Table: aws_cloudformation_stack

Examples

Find the status of each cloudformation stack

List of cloudformation stack where rollback is disabled

List of stacks where termination protection is not enabled

Rollback configuration info for each cloudformation stack

Resource ARNs where notifications about stack actions will be sent

Query examples

.inspect aws_cloudformation_stack

Steampipe

Resources

Community