Axiom Data Explorer provides a robust computation and processing power to get deeper insights on your data.
With the Data Explorer, you will be able to filter, manipulate, extend, and summarize your data whenever you want, without having to worry about query speed or indexes.
Data Explorer queries the same data you've already ingested into Axiom. Learn more about ingestion here.
- Select Data Explorer from the menu bar.
Configure your workflow on Axiom Data Explorer and start performing queries on your Dataset.
- A simple query has been performed on the ingested data as shown below.
- The first line is the name of your dataset you want to turn your query on. Here, the name of my dataset is
- In the second line, we are selecting the
fieldsto insert and embed into the new computed columns using the
- In the table below, you can see the output we got it returned a table that has the
fieldnamed as arguments, and as many rows as the input table.
Data Explorer's query language is APL, and it's a data processing language that supports filtering, extending, and summarizing data.
Data Explorer has a rich query engine featuring the intuitive Axiom Processing language and powerful ingestion and storage capabilities that is optimized for low latency ingestion and super-fast query performance.
Axiom Processing Language
Below are some APL commands to get you familiarized as to how APL queries look like on Axiom Data Explorer.
NOTE: In these queries below, the pipe symbol
| separates the operations as they flow from left to right, and top to bottom.
APL is case-sensitive for everything – dataset names, table column names, operators, functions, etc.
Use double forward slashes
// for comments.
APL Count operator
The below query returns the number of events from the
APL Limit operator
limit n operator returns a random subset
n up to the specified number of rows. This query returns a thousand rows from
http-logs, randomly chosen by APL.
APL Summarize operator
summarize operator produces a table that aggregates the content of the dataset. This query returns a chart of the
Avg(req_duration_ms) and a table of
AVG(req_duration_ms) of the
http-logs dataset from the time range of 2 days and time interval of 4 hours.