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.

Alias Name	Main Name
distinct	dedup
set_pk	set_primary_key
bucketize	timechart