DQL commands

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.

timeseries

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

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.

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.

parse

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

limit

Limits the number of returned records.

sort

Sorts the records.

expand

Expands an array into separate records.

fieldsFlatten

Extracts/flattens fields from a nested record.

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.

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.