steampipe plugin install awssteampipe plugin install aws

Table: aws_cloudformation_stack_set

AWS CloudFormation Stack Set is a service that allows you to create, update, or delete stacks across multiple accounts and regions with a single CloudFormation template. It provides centralized management and deployment of CloudFormation stacks, making it easier to manage infrastructure resources across a large number of accounts and regions. Stack Sets can be used to enforce compliance policies, deploy standard infrastructure configurations, and simplify the management of infrastructure changes at scale.

Examples

Basic info

select
  stack_set_id,
  stack_set_name,
  status,
  arn,
  description
from
  aws_cloudformation_stack_set;

List active stack sets

select
  stack_set_id,
  stack_set_name,
  status,
  permission_model,
  auto_deployment
from
  aws_cloudformation_stack_set
where
  status = 'ACTIVE';

Get parameter details of stack sets

select
  stack_set_name,
  stack_set_id,
  p ->> 'ParameterKey' as parameter_key,
  p ->> 'ParameterValue' as parameter_value,
  p ->> 'ResolvedValue' as resolved_value,
  p ->> 'UsePreviousValue' as use_previous_value
from
  aws_cloudformation_stack_set,
  jsonb_array_elements(parameters) as p;

Get drift detection details of stack sets

select
  stack_set_name,
  stack_set_id,
  stack_set_drift_detection_details ->> 'DriftDetectionStatus' as drift_detection_status,
  stack_set_drift_detection_details ->> 'DriftStatus' as drift_status,
  stack_set_drift_detection_details ->> 'DriftedStackInstancesCount' as drifted_stack_instances_count,
  stack_set_drift_detection_details ->> 'FailedStackInstancesCount' as failed_stack_instances_count,
  stack_set_drift_detection_details ->> 'InProgressStackInstancesCount' as in_progress_stack_instances_count,
  stack_set_drift_detection_details ->> 'InSyncStackInstancesCount' as in_sync_stack_instances_count,
  stack_set_drift_detection_details ->> 'LastDriftCheckTimestamp' as last_drift_check_timestamp,
  stack_set_drift_detection_details ->> 'TotalStackInstancesCount' as total_stack_instances_count
from
  aws_cloudformation_stack_set;

.inspect aws_cloudformation_stack_set

AWS CloudFormation Stack Set

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.
administration_role_arn	text	The Amazon Resource Name (ARN) of the IAM role used to create or update the stack set.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) of the stack set.
auto_deployment	jsonb	Describes whether StackSets automatically deploys to Organizations accounts that are added to a target organizational unit (OU).
capabilities	jsonb	The capabilities that are allowed in the stack set.
description	text	A description of the stack set that you specify when the stack set is created or updated.
drift_status	text	Status of the stack set's actual configuration compared to its expected template and parameter configuration. A stack set is considered to have drifted if one or more of its stack instances have drifted from their expected template and parameter configuration.
execution_role_name	text	The name of the IAM execution role used to create or update the stack set.
last_drift_check_timestamp	timestamp with time zone	Most recent time when CloudFormation performed a drift detection operation on the stack set.
managed_execution	jsonb	Describes whether StackSets performs non-conflicting operations concurrently and queues conflicting operations.
organizational_unit_ids	jsonb	The organization root ID or organizational unit (OU) IDs that you specified for DeploymentTargets.
parameters	jsonb	A list of input parameters for a stack set.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
permission_model	text	Describes how the IAM roles required for stack set operations are created.
region	text	The AWS Region in which the resource is located.
stack_set_drift_detection_details	jsonb	Detailed information about the drift status of the stack set.
stack_set_id	text	The ID of the stack set.
stack_set_name	text	The name of the stack set.
status	text	The status of the stack set.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags associated with stack.
template_body	text	The structure that contains the body of the template that was used to create or update the stack set.
title	text	Title of the resource.

turbot/aws