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 |
---|---|
Generates sample data during query runtime. | |
Describes the on-read schema extraction definition for a given data object. | |
Loads data from the specified resource. |
Metric commands
Name | Description |
---|---|
Combines loading, filtering and aggregating metrics data into a time series output. |
Filtering commands
Name | Description |
---|---|
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. |
Selection and modification commands
Name | Description |
---|---|
Keeps only specified fields. | |
Evaluates an expression and appends or replaces a field. | |
Keeps selected fields. | |
Removes fields from the result. | |
Renames a field. |
Extraction and parsing commands
Name | Description |
---|---|
Parses a record field and puts the result into one or more fields as specified in the pattern. |
Ordering commands
Structuring commands
Name | Description |
---|---|
Expands an array into separate records. | |
Extracts/flattens fields from a nested record. |
Aggregation commands
Name | Description |
---|---|
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. |
Correlation and join commands
Name | Description |
---|---|
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. |