Table: aws_resource_explorer_supported_resource_type - Query AWS Resource Explorer Supported Resource Types using SQL
The AWS Resource Explorer Supported Resource Types is a feature of AWS Resource Groups that allows you to view and manage your AWS resources. This service organizes your resources based on their types and the AWS services that they belong to. By using SQL queries, you can easily locate and manage your resources, allowing for efficient resource management.
Table Usage Guide
The aws_resource_explorer_supported_resource_type
table in Steampipe provides you with information about supported resource types for AWS Resource Groups. This table allows you, as a DevOps engineer or other technical professional, to query details about supported resource types, including their names and whether they can be included in a resource group. You can utilize this table to gather insights on resource types, such as which resources can be grouped together for easy management and configuration. The schema outlines the various attributes of the supported resource type for you, including the resource type and whether it is groupable.
Examples
Basic info
Determine the areas in which specific services and resources types are supported within AWS. This can help in understanding the availability and compatibility of various services across different resource types.
select service, resource_typefrom aws_resource_explorer_supported_resource_type;
select service, resource_typefrom aws_resource_explorer_supported_resource_type;
List supported IAM resource types
Determine the areas in which IAM resources are supported within a specific service, allowing for more efficient management and allocation of resources.
select service, resource_typefrom aws_resource_explorer_supported_resource_typewhere service = 'iam';
select service, resource_typefrom aws_resource_explorer_supported_resource_typewhere service = 'iam';
Schema for aws_resource_explorer_supported_resource_type
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
account_id | text | =, !=, ~~, ~~*, !~~, !~~* | The AWS Account ID in which the resource is located. |
partition | text | The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov). | |
resource_type | text | The unique identifier of the resource type. | |
service | text | The Amazon Web Service that is associated with the resource type. This is the primary service that lets you create and interact with resources of this type. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws
You can pass the configuration to the command with the --config
argument:
steampipe_export_aws --config '<your_config>' aws_resource_explorer_supported_resource_type