DDSQL Editor

이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

Join the Beta!

DDSQL Editor is in private beta.

Overview

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

The result of a SQL query shown 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.

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.

SELECT instance_type, count(instance_type)
FROM aws_ec2_instance
WHERE env = 'staging' -- env is a tag, not a column
GROUP BY instance_type

For more information on DDSQL queries, see the DDSQL References:

Functions

Data Types

Expressions and Operators

Statements

Explore your infrastructure data

View and filter the list of tables and fields in the schema side panel:

Click a table name to view its columns and relationships:

The details of a table, including its columns and relationships

Save useful queries, or export the data as CSV.

A query result with the save and export actions shown

Browse and re-run saved queries in the side panel.

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.