DDSQL Editor

Docs > DDSQL Editor

Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel, n'hésitez pas à nous contacter.

Advanced Data Sources

If you want to query data sources not yet available, use the following form to submit your request. For a full list of supported data sources, see the Data Directory.

Request Access

Overview

With DDSQL Editor, you can get deeper visibility into your telemetry by querying your resources with natural language or with DDSQL, a dialect of SQL with additional support for querying tags.

You can also export the results of a DDSQL query to visualize in a Dashboard or Notebook or to automate in a Datadog Workflow through DDSQL Action.

The result of a SQL query showing average CPU usage by host on the DDSQL page in Datadog

Query in natural language

Type your question into the search box, and Datadog builds the SQL query for you. You can accept or discard changes, and can provide feedback to help improve the feature.

A query inputted into the natural language search box

Use SQL syntax (DDSQL)

DDSQL is a query language for Datadog data. It implements several standard SQL operations, such as SELECT, and allows queries against unstructured data, such as tags. Get exactly the data you want by writing your own SELECT statement. Query tags as if they are standard table columns. For more information, see the DDSQL Reference.

SELECT instance_type, count(instance_type)
FROM aws.ec2_instance
WHERE tags->'region' = 'us-east-1' -- region is a tag, not a column
GROUP BY instance_type

Explore your telemetry

View, filter, and built queries in the Data Explorer.

Click a table name to view its columns and relationships:

The data tab showing table information for aws.ec2_instance

For data sources such as Logs, use the query builder to generate table functions.

Save useful queries for future reference or download the data as CSV. Browse and re-run recent or saved queries in the side panel.

DDSQL Editor interface showing query results with save and actions downdown highlighted

Export the results of a saved query to:

A Dashboard or Notebook for visualization and reporting
Automate using a DDSQL Action in a Datadog Workflow, with which you can:
Alert on a DDSQL query in Preview (Logs, Metrics, RUM, Spans, and Product Analytics only; contact support for access)

Side panel showing the Queries tab with a list of saved and recent queries in the DDSQL Editor

Permissions

To access the DDSQL Editor app, users need the ddsql_editor_read permission. This permission is included in the Datadog Read Only Role by default. If your organization uses custom roles, add this permission to the appropriate role. For more information on managing permissions, see the RBAC documentation.