Query: Find stack resource by physical resource ID

Description

Quickly locate a specific CloudFormation resource using its physical resource ID (e.g., ARN, instance ID, etc.). This is useful for mapping physical AWS resources back to their CloudFormation stack and logical resource definition.

Query

Tables used in this query:

• aws_cloudformation_stack_resource

SQL