> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.omni.co/feedback

```json
{
  "path": "/modeling/views/parameters/default-drill-query",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# default_drill_query

> Set the default drill query for all measures in a view.

Refer to the [Measure documentation](/modeling/measures/parameters/drill-queries) for more information.

## Syntax

```yaml theme={null}
default_drill_query:
  fields: [ <field1>, <field2> ... ]
  base_view: <view_name>
  limit: number
  sorts: [ <view>.<field>, ... ]
```

## Properties

<ParamField path="fields" type="array">
  An array of fields to include in the drill query.
</ParamField>

<ParamField path="base_view" type="string">
  The table that will act as the `FROM` clause of the query.
</ParamField>

<ParamField path="limit" type="number">
  The number of rows to return in the drill query.
</ParamField>

<ParamField path="sorts" type="array">
  An array of fields used to sort the query, specified as `view_name.field_name`.
</ParamField>

## Examples

```yaml title="Default drill query configuration for orders" theme={null}
default_drill_query:
  fields: [ sale_price, margin ]
  base_view: orders
  limit: 10
  sorts: [ orders.user_id ]
```