Plugins

turbot/awscfn

GitHub
Overview
4Tables
Versions
GitHub
steampipe plugin install awscfnsteampipe plugin install awscfn
awscfn_mappingawscfn_outputawscfn_parameterawscfn_resource
On This Page
Examples
.inspect
Get Involved
Discuss on Slack

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.