NRQL productivity improvements makes querying faster with anchor parse, regex multi-capture, and more.
Making sense of complex data like log messages just got easier! With NRQL variables, the new
if() functions, you can obtain useful information from your data more efficiently and gain insights faster.
With NRQL variables, you can assign values to variables and use them multiple times in your query. The
if() function lets you select one of two results based on a condition that's either true or false. In addition, we've enhanced our existing regex
capture() function to allow multiple capture groups, for simpler queries with better performance!
In this example, we extract an item ID, and unit price from a log message, and additionally show which pricing tier the item falls into:
The aparse() function is a simpler, faster alternative to capture() for use when you don't require the full power of regular expressions. With aparse(), use "anchor" text and the '*' wildcard to capture the fields you need:
Check out this demo NerdByte video on the new NRQL query components