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, pathfrom awscfn_output;
List outputs that return an EC2 instance public DNS name
select name, value, description, pathfrom awscfn_outputwhere 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.pathfrom output_table as o left join awscfn_parameter as p on p.name = o.parameter_reference and o.path = p.pathwhere p.no_echo;
.inspect awscfn_output
CloudFormation resource information
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
description | text | A 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. |
export | jsonb | The name of the resource output to be exported for a cross-stack reference. |
name | text | An identifier for the current output. |
path | text | Path to the file. |
start_line | bigint | Starting line number. |
value | text | The 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. |