Skip to main content

resources

Creates, updates, deletes, gets or lists a resources resource.

Overview

Nameresources
TypeResource
Idaws.resource_explorer_2.resources

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
arnstringThe Amazon resource name (ARN) of the resource.
cfn_resource_typestringThe CloudFormation resource type identifier for the resource, such as AWS::EC2::Instance or AWS::S3::Bucket.
last_reported_atstring (date-time)The date and time that Resource Explorer last queried this resource and updated the index with the latest information about the resource.
owning_account_idstringThe Amazon Web Services account that owns the resource.
propertiesarrayA structure with additional type-specific details about the resource. These properties can be added by turning on integration between Resource Explorer and other Amazon Web Services services.
regionstringThe Amazon Web Services Region in which the resource was created and exists.
resource_typestringThe type of the resource.
servicestringThe Amazon Web Services service that owns the resource and is responsible for creating and updating it.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_resourcesselectregionReturns a list of resources and their details that match the specified criteria. This query must use a view. If you don’t explicitly specify a view, then Resource Explorer uses the default view for the Amazon Web Services Region in which you call this operation.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Returns a list of resources and their details that match the specified criteria. This query must use a view. If you don’t explicitly specify a view, then Resource Explorer uses the default view for the Amazon Web Services Region in which you call this operation.

SELECT
arn,
cfn_resource_type,
last_reported_at,
owning_account_id,
properties,
region,
resource_type,
service
FROM aws.resource_explorer_2.resources
WHERE region = '{{ region }}' -- required
;