DQL commands

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.

Data source commands

Name	Description
data	Generates sample data during query runtime.
describe	Describes the on-read schema extraction definition for a given data object.
fetch	Loads data from the specified resource.

Metric commands

Name	Description
timeseries	Combines loading, filtering and aggregating metrics data into a time series output.

Filtering commands

Name	Description
dedup	Removes duplicates from a list of records.
filter	Reduces the number of records in a list by keeping only those records that match the specified condition.
filterOut	Removes records that match a specific condition.

Selection and modification commands

Name	Description
fields	Keeps only specified fields.
fieldsAdd	Evaluates an expression and appends or replaces a field.
fieldsKeep	Keeps selected fields.
fieldsRemove	Removes fields from the result.
fieldsRename	Renames a field.

Extraction and parsing commands

Name	Description
parse	Parses a record field and puts the result into one or more fields as specified in the pattern.

Ordering commands

Name	Description
limit	Limits the number of returned records.
sort	Sorts the records.

Structuring commands

Name	Description
expand	Expands an array into separate records.
fieldsFlatten	Extracts/flattens fields from a nested record.

Aggregation commands

Name	Description
fieldsSummary	Calculates the cardinality of field values that the specified fields have.
makeTimeseries	Creates timeseries from the data in the stream.
summarize	Groups together records that have the same values for a given field and aggregates them.

Correlation and join commands

Name	Description
append	Appends a given list of records by the records returned by a sub-query.
join	Joins all records from the source and the sub-query as long as they fulfill the join condition.
joinNested	Adds matching results from the sub-query as an array of nested records.
lookup	Adds fields from a subquery to the source table by finding a match between a field in the source table and the lookup table.