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.
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 fields from a subquery to the source table by finding a match between a field in the source table and the lookup table.