Query Editor: Selecting tags as output columns

[Wenzil]

Hello there,

Can you add functionality to select resource tags as columns?

For example, this query would output a Name column and contain the name of every EC2 instance:

SELECT
  resourceId,
  tag.Name
WHERE
  resourceType = 'AWS::EC2::Instance'

[jprakash402]

I'm looking for something similar to this. Is there a way to fetch, values from array?

SELECT
  configuration.natGatewayAddresses.networkInterfaceId,
  configuration.natGatewayAddresses.privateIp,
  configuration.natGatewayAddresses.publicIp,
  resourceId
WHERE
  resourceType = 'AWS::EC2::NatGateway'

The above query is giving empty values instead of actual data.

[renanr0ssi]

Hello there,

Can you add functionality to select resource tags as columns?

For example, this query would output a Name column and contain the name of every EC2 instance:

SELECT
  resourceId,
  tag.Name
WHERE
  resourceType = 'AWS::EC2::Instance'

Did you find any way to do this? I'm in the same situation!

[alanreynosov]

Any Update? there's lot of resources with No resourceName but Tag Name, this capability would be great

[alanreynosov]

there's a workaround, sending config outputs to a bucket and query with AWS Athena and json_extract_scalar;

SELECT resourceId, json_extract_scalar(tags.key, '$.Name') as Name

https://aws.amazon.com/blogs/mt/how-to-query-your-aws-resource-configuration-states-using-aws-config-and-amazon-athena/

[albertorm95]

Looks like there is no intention of developing this

[runjivu]

Not being able to query by resource name (witch is commonly in tag key "Name") is critical. I really hope they work on this