This page provides a list of DQL commands grouped by categories. To get more in-depth information on a specific command, click on its name.
Generates sample data during query runtime.
Describes the on-read schema extraction definition for a given data object.
Loads data from the specified resource.
Combines loading, filtering and aggregating metrics data into a time series output.
Removes duplicates from a list of records.
Reduces the number of records in a list by keeping only those records that match the specified condition.
Removes records that match a specific condition.
Keeps only specified fields.
Evaluates an expression and appends or replaces a field.
Keeps selected fields.
Removes fields from the result.
Renames a field.
Parses a record field and puts the result into one or more fields as specified in the pattern.
Expands an array into separate records.
Extracts/flattens fields from a nested record.
Calculates the cardinality of field values that the specified fields have.
Creates timeseries from the data in the stream.
Groups together records that have the same values for a given field and aggregates them.
Appends a given list of records by the records returned by a sub-query.
Joins all records from the source and the sub-query as long as they fulfill the join condition.
Adds matching results from the sub-query as an array of nested records.
Adds fields from a subquery to the source table by finding a match between a field in the source table and the lookup table.
- How to use DQL queries
Find out how DQL works and what are DQL key concepts.
- DQL language reference
Dynatrace Query Language syntax reference.
- DQL Functions
A list of DQL functions.
- DQL operators
A list of DQL Operators.
- DQL data types
A list of DQL data types.
- DQL Best practices
Best practices for using Dynatrace Query Language.