Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Preferences
Contact Us
Feedback
AWS Documentation
Create an AWS Account

Create a new widget from a SQL query with the CloudTrail console

PDF
RSS
Focus mode
Create a new widget from a SQL query with the CloudTrail console - AWS CloudTrail

This section describes how to create a new widget by writing or pasting a SQL query and choosing a chart type. You can add a maximum of 10 widgets to a custom dashboard.

To create a new widget from a SQL query

  1. Sign in to the AWS Management Console and open the CloudTrail console at https://console.aws.amazon.com/cloudtrail/.

  2. In the left navigation pane, under Lake, choose Dashboard.

  3. Choose the Managed and custom dashboards tab.

  4. In Custom dashboards, choose the dashboard that you want to create a widget for.

  5. From Actions, choose Edit dashboard.

  6. From Actions, choose Create new widget.

  7. Choose the event data store you'd like to run the query on. You can query across multiple event data stores as long as the event data stores exist in your account.

  8. Write or copy the SQL query.

    You can also provide a natural language prompt in English and choose Generate query to produce a SQL query from your prompt. For more information, see Create CloudTrail Lake queries from natural language prompts.

  9. Choose Run to run the query and preview the query results.

    Note

    When you run queries, you incur charges based on the amount of optimized and compressed data scanned. To help control costs, we recommend that you constrain queries by adding starting and ending eventTime timestamps to queries.

  10. Choose the Visualizer tab to select the chart type for the widget. You can choose from these chart types: table, bar chart, line chart, and pie chart.

  11. Choose Add to dashboard to add the widget to the dashboard.

  12. Choose Save to save the dashboard.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.