All OPAL verbs

Opal verbs process sets of rows of columns.

Verb

Description

add_key

Add a candidate key to the output. The candidate key…

aggregate

Aggregates metrics across tag dimensions.

align

Align raw metrics onto a time grid (defined by the…

always

Select data for resources that matched the predicate…

colenum

Mark columns as enumerations, or not, by name….

colimmutable

Mark resource columns as time immutable a.k.a….

colshow

Show or hide columns by name. Arguments are colname:…

dedup

dedup collapses all rows in an event dataset with…

drop_col

Exclude one or more columns from the input dataset…

droptime

Clear the valid from (and the valid to), turning…

ever

Select data for resources that at some point matched…

exists

Return the rows from the default dataset that have a…

extract_regex

Add one or more columns by matching capture names in…

filter

Exclude rows from the input dataset that do not…

flatten

Given an input of object or array type, recursively…

flatten_all

Given an input of object or array type, recursively…

flatten_leaves

Given an input of object or array type, recursively…

flatten_single

Given an input of object or array type, flatten the…

follow

Return the rows from the additional joined dataset…

fulljoin

Temporal full join, adding new columns in the output…

interface

Map fields of this dataset to a pre-defined interface.

join

Temporal inner join, adding new columns in the…

leftjoin

Temporal left join, adding new columns in the output…

lookaround_join

Lookaround join is a type of inner join. Where this…

lookup

Find matching rows in a resource, making new columns…

make_col

Add one or more new columns from the input dataset…

make_event

Given a resource, make_event will demote it to a…

make_resource

Convert an event table to a resource with the…

make_session

Group events or intervals that are close to each…

merge_events

Merge consecutive events into new events based on…

never

Select data for resources that at no point matched…

pick_col

Exclude all columns except the specified columns…

rename_col

Include all columns while renaming the specified…

rollup

Rollup raw metrics into aligned metrics

set_label

Declare the ‘label’ of the output to be the designat…

set_link

Add a foreign key to the output. The foreign key…

set_metric

Register a metric, with its metadata defined in an…

set_primary_key

Declare the primary key of the output as consisting…

set_valid_from

Declare the valid from of the output to be the…

set_valid_to

Declare the ‘valid to’ of the output to be the named…

statsby

Calculate statistics of columns with aggregate…

surrounding

Rows from the “right” dataset that fall within the…

timechart

Bin (in time) and aggregate point or interval table…

timestats

Aggregate resource columns at every point in time,…

topk

Selects all data for each of top k ranked groups. If…

union

Create a new event dataset, consisting of events…

unset_keys

Remove the primary and candidate key declarations…

unset_link

Drop a foreign key by specifying the foreign keys…

update_resource

Update the current resource by merging an event (or…

Aliases

Aliases work as alternative names for their main verb. Users of certain other query languages may be more comfortable with these alternative names. Alias names on this list can always be used whenever the main name can be used.