All OPAL verbs¶
Opal verbs process sets of rows of columns.
Verb |
Description |
---|---|
Add a candidate key to the output. The candidate key… |
|
Aggregates metrics across tag dimensions. |
|
Align raw metrics onto a time grid (defined by the… |
|
Select data for resources that matched the predicate… |
|
Mark columns as enumerations, or not, by name…. |
|
Mark resource columns as time immutable a.k.a…. |
|
Show or hide columns by name. Arguments are colname:… |
|
dedup collapses all rows in an event dataset with… |
|
Exclude one or more columns from the input dataset… |
|
Clear the |
|
Select data for resources that at some point matched… |
|
Return the rows from the default dataset that have a… |
|
Add one or more columns by matching capture names in… |
|
Exclude rows from the input dataset that do not… |
|
Given an input of object or array type, recursively… |
|
Given an input of object or array type, recursively… |
|
Given an input of object or array type, recursively… |
|
Given an input of object or array type, flatten the… |
|
Return the rows from the additional joined dataset… |
|
Temporal full join, adding new columns in the output… |
|
Map fields of this dataset to a pre-defined interface. |
|
Temporal inner join, adding new columns in the… |
|
Temporal left join, adding new columns in the output… |
|
Lookaround join is a type of inner join. Where this… |
|
Find matching rows in a resource, making new columns… |
|
Add one or more new columns from the input dataset… |
|
Given a resource, make_event will demote it to a… |
|
Convert an event table to a resource with the… |
|
Group events or intervals that are close to each… |
|
Merge consecutive events into new events based on… |
|
Select data for resources that at no point matched… |
|
Exclude all columns except the specified columns… |
|
Include all columns while renaming the specified… |
|
Rollup raw metrics into aligned metrics |
|
Declare the ‘label’ of the output to be the designat… |
|
Add a foreign key to the output. The foreign key… |
|
Register a metric, with its metadata defined in an… |
|
Declare the primary key of the output as consisting… |
|
Declare the |
|
Declare the ‘valid to’ of the output to be the named… |
|
Calculate statistics of columns with aggregate… |
|
Rows from the “right” dataset that fall within the… |
|
Bin (in time) and aggregate point or interval table… |
|
Aggregate resource columns at every point in time,… |
|
Selects all data for each of top k ranked groups. If… |
|
Create a new event dataset, consisting of events… |
|
Remove the primary and candidate key declarations… |
|
Drop a foreign key by specifying the foreign keys… |
|
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.