turbot/awscfn

GitHub
steampipe plugin install awscfnsteampipe plugin install awscfn

Table: awscfn_output

The Outputs section declares output values that you can import into other stacks (to create cross-stack references), return in response (to describe stack calls), or view on the AWS CloudFormation console. For example, you can output the S3 bucket name for a stack to make the bucket easier to find.

Examples

Basic info

select
name,
description,
value,
path
from
awscfn_output;

List outputs that return an EC2 instance public DNS name

select
name,
value,
description,
path
from
awscfn_output
where
value like '%Fn::GetAtt:%PublicDnsName%';

List outputs that show sensitive parameter values

with output_table as (
select
name,
description,
split_part(
substring(
value
from
'\w*Ref:*\w*'
),
':',
2
) as parameter_reference,
path
from
awscfn_output
where
value like '%Ref:%'
)
select
o.name,
o.description,
o.path
from
output_table as o
left join awscfn_parameter as p on p.name = o.parameter_reference
and o.path = p.path
where
p.no_echo;

.inspect awscfn_output

CloudFormation resource information

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
descriptiontextA String type that describes the output value. The value for the description declaration must be a literal string that's between 0 and 1024 bytes in length. You can't use a parameter or function to specify the description. The description can be a maximum of 4 K in length.
exportjsonbThe name of the resource output to be exported for a cross-stack reference.
nametextAn identifier for the current output.
pathtextPath to the file.
start_linebigintStarting line number.
valuetextThe value of the property returned by the aws cloudformation describe-stacks command. The value of an output can include literals, parameter references, pseudo-parameters, a mapping value, or intrinsic functions.