Query Using the SQL Query Editor (Console) - Amazon Config
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Query Using the SQL Query Editor (Console)

Introducing a preview feature for advanced queries that allows you to use generative artificial intelligence (generative AI) capabilities to ask questions in plain English and convert them into a ready-to-use query format. For more information, see Natural language query processor for advanced queries.

You can either use Amazon sample queries or you can create your own query called as custom queries.

Prerequisites

You must have permissions for the config:SelectResourceConfig and config:SelectAggregateResourceConfig APIs. For more information, see SelectResourceConfig API and SelectAggregateResourceConfig API.

You must have permissions for the AWSConfigUserAccess IAM managed policy. For more information, see Read-only access to Amazon Config.

Note

If you are using AWSServiceRoleForConfig (service linked role) or AWSConfigRole, you will already have permissions to save a query.

If you are not using either of these roles, you must have permissions to config:PutStoredQuery, config:GetStoredQuery, config:TagResource, config:UntagResource, config:ListTagsForResource and config:GetResources.

Use an Amazon Sample Query

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Config console at https://console.amazonaws.cn/config/.

  2. Choose Advanced queries from the left navigation to query your resource configurations for a single account and Region or for multiple accounts and Regions.

  3. On the Advanced queries page, choose an appropriate query from the list of queries. You can filter through the list of queries either by the name, description, creator, or tags. To filter for Amazon queries, choose Creator, and enter Amazon. The query that you select is displayed in the SQL query editor. You can edit the selected query to fit your needs.

    Important

    An updated list of properties and their data types is available in GitHub.

    Note

    To run a query on an aggregator, create an aggregator. For more information, see .

    If you already have an aggregator set up, in the query scope, choose the aggregator to run an advanced query on that aggregator. When you select an aggregator, consider adding the Amazon account ID and Amazon Region in the query statement to view that information in the results.

  4. To save this query to a new query, choose Save As.

    • In the Query Name field, update the name of the query.

    • In the Description field, update the description of the query.

    • Enter up to 50 unique tags for this query.

    • Choose Save.

  5. Choose Run. The query results are displayed in the table below the query editor.

  6. Choose Export as to export the query results in CSV or JSON format.

    Note

    The query results are paginated. When you choose export, up to 500 results are exported.

    You can also use the APIs to retrieve all the results. The results are paginated and you can retrieve 100 results at a time.

Create your custom query

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Config console at https://console.amazonaws.cn/config/.

  2. Choose Advanced queries from the left navigation to query your resource configurations for a single account and Region or for multiple accounts and Regions.

  3. To create your custom query, choose New query.

    Important

    An updated list of properties and their data types is available in GitHub.

    Note

    To view or edit a custom query, filter a query either by the name, description, creator or tags. To filter custom queries, choose Creater and enter Custom.

  4. On the Query editor page, create your own query for this account and Region. You can also select an appropriate aggregator to create a query for multiple accounts and Regions.

    Note

    To run a query on an aggregator, create an aggregator. For more information, see .

    If you already have an aggregator set up, in the query scope, choose the aggregator to run an advanced query on that aggregator. When you select an aggregator, consider adding the Amazon account ID and Amazon Region in the query statement to view that information in the results.

  5. Edit if you wish you make changes to this query. Choose Save Query to save this query.

    • In the Query Name field, update the name of the query.

    • In the Description field, update the description of the query.

    • Enter up to 50 unique tags for this query.

    • Choose Save.

  6. Choose Run. The query results are displayed in the table below the query editor.

  7. Choose Export as to export the query results in CSV or JSON format.

    Note

    The query results are paginated. When you choose export, up to 500 results are exported.

    You can also use the APIs to retrieve all the results. The results are paginated and you can retrieve 100 results at a time.