Copy as Markdown[Open in ChatGPT](https://chatgpt.com/?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fuser-guides%2Folly%2Fdataprime-query-assistance.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)[Open in Claude](https://claude.ai/new?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fuser-guides%2Folly%2Fdataprime-query-assistance.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)

# DataPrime query assistance

Describe what you're looking for in everyday language, and Olly converts your description into a structured DataPrime query, saving you the trouble of writing complex queries manually.

DataPrime query assistance is one of the [Olly mini](https://coralogix.com/docs/user-guides/olly/olly-mini.md) features, focused, in-context AI actions embedded across Coralogix. Like other Olly mini features, generating queries consumes [AI Units](https://coralogix.com/docs/user-guides/account-management/payment-and-billing/ai-units-pricing.md) and is billed per token at the model's rate.

[![DataPrime query assistance](/docs/assets/images/dataprime-assistance-afa0d73ca652299fb999005b2814bb9c.webp)](https://coralogix.com/docs/assets/images/dataprime-assistance-afa0d73ca652299fb999005b2814bb9c.webp)

## How it works[​](#how-it-works "Direct link to How it works")

DataPrime Query Assistance uses a large language model (LLM) to interpret natural language requests and generate precise DataPrime queries.

* **Natural language to structured queries**: Enter your request in plain English, and Olly generates a DataPrime query
* **Flexible query modification**: After the query is generated, review and adjust it in the DataPrime editor before running it
* **Smart input evaluation**: Olly detects and corrects spelling mistakes, prevents syntax errors, and validates that input is within DataPrime scope. Invalid input is automatically rejected.

Note

LLM-based systems are still evolving and can make mistakes. Validate any generated DataPrime query before running it.

## Limitations[​](#limitations "Direct link to Limitations")

* DataPrime query assistance supports single-turn interaction only, one prompt and one generated query per session.
* Maximum prompt length is 700 characters.

## Query examples[​](#query-examples "Direct link to Query examples")

Common queries with example prompts and generated DataPrime output:

Simple field-based filter

Prompt: Show me all logs with application name default

```
source logs

| filter $l.applicationname == 'default'
```

Multiple filters

Prompt: Show me all logs with severity error or higher where the subsystem name is archive

```
source logs

| filter $m.severity >= ERROR

| filter $l.subsystemname == 'archive'
```

Aggregation

Prompt: Count all errors by application name

```
source logs

| filter $m.severity == ERROR

| groupby $l.applicationname aggregate count() as error_count
```

Aggregation and filtering

Prompt: Show me all logs where the cloud provider is aws and group it by subsystem

```
source logs

| filter $d.resource.attributes['cloud.provider'] == 'aws'

| groupby $l.subsystemname
```

Advanced calculation

Prompt: Find the average grpc.timems where grpc code is not ok

```
source logs

| filter $d.grpc.code != 'ok'

| groupby true aggregate avg($d.grpc.timems) as average_grpc_times
```

Note

Due to DataPrime limitations, aggregate functions (`sum`, `avg`, `count`, etc.) require a computation anchor. The `groupby true aggregate` expression serves as a boolean anchor for the aggregate function.

## Prerequisites[​](#prerequisites "Direct link to Prerequisites")

Olly must be enabled for your team. See [Enable Olly](https://coralogix.com/docs/user-guides/olly/enable.md).

## Enable DataPrime Query Assistance[​](#enable-dataprime-query-assistance "Direct link to Enable DataPrime Query Assistance")

1. Verify that you have permission to manage AI settings.
2. Go to **Settings**, then **Account Preferences**.
3. Under **AI-Powered Capabilities**, turn on the **DataPrime Query Assistance** toggle.

## Use DataPrime query assistance[​](#use-dataprime-query-assistance "Direct link to Use DataPrime query assistance")

1. In **Explore**, select the dataset you want to query, then switch the query syntax to **DataPrime**.
2. The AI query prompt appears above the DataPrime editor. If it's hidden, open the query bar's menu and select **Show Prompt AI**.
3. In the prompt box (**Ask Olly to write a query…**), describe what you're looking for, then select **Generate query** or press Enter. Olly generates a DataPrime query for the dataset you selected, logs, spans, or any other dataset you query in Explore.
4. Review the generated query and adjust it in the DataPrime editor if needed, then run the query. If your request implies a time range (for example, "errors in the last 3 hours") Olly sets the time picker to that window when you run the query.

To hide the prompt from the query bar, open the query bar's menu and select **Hide Prompt AI**. Select **Show Prompt AI** from the same menu to bring it back.

## Feedback[​](#feedback "Direct link to Feedback")

Rate Olly's responses with a thumbs up or thumbs down to help improve query generation quality.

* Select thumbs up if the generated query is accurate
* Select thumbs down and complete the feedback form to report issues or suggest improvements

## Next steps[​](#next-steps "Direct link to Next steps")

Get clear, natural language explanations for individual log entries with [Explain Log](https://coralogix.com/docs/user-guides/olly/explain-log.md).