DQL Table
- Latest Dynatrace
- Reference
- 8-min read
- Published Jul 13, 2026
type: 'dql-table'
A data table driven by a DQL query, with columns, filtering, grouping, and perspectives. Usually the main component of an explorer view.
Fields
In addition to the shared CoreElement fields (see Elements overview):
| Property | Type | Description |
|---|---|---|
|
| Card title. |
|
| Card description. |
|
| The base query, lookups, and additional commands that populate the table. |
|
| Column definitions. Mix custom columns with built-in references. |
|
| Named column-visibility/sort presets the user can switch between. |
|
| Name of the perspective selected by default. |
|
| Health indicator config. See Health indicators. |
|
| Row-grouping configuration. |
|
| Rules for highlighting or marking rows based on field values. |
|
| Field used to highlight the active row (matched against the |
|
| Layout rendered inside an expanded row. |
|
| When true, clicking a row toggles its expandable content instead of navigating. |
|
| Height reserved for expanded row content. |
|
| Toolbar action buttons. |
|
| Actions available per cell. |
|
| Actions available per row. |
|
| Card-level action buttons. |
|
| Show a search box in the toolbar/header. |
|
| Enable row selection. |
|
| Fields always fetched from Grail, even when not visible as columns. |
|
| Controls DQL generation details such as limits and lookup ordering. |
|
| Overall table density/mode. |
|
| Loading indicator style. |
|
|
|
DqlTableQuery
Describes the data that populates the table. It is composed of:
- a main query (
query) that produces the primary set of rows, and - optional lookups and additionalCommands that append extra data used by columns.
Every field referenced by a column must be provided by one of these queries. If a field is not found among the lookups or additionalCommands outputs, it is assumed to come from the main query.
| Property | Type | Description |
|---|---|---|
|
| Field that uniquely identifies each row. Required to merge lazily-fetched columns back into rows. |
|
| The base DQL query that provides the main set of rows. |
|
| Lookup queries joined onto the base query to append fields. |
|
| Extra query fragments that compute derived fields. |
DqlTableLookup
| Property | Type | Description |
|---|---|---|
|
| The lookup query. |
|
| Field in the base query to join on. |
|
| Field in the lookup query to join on. |
|
| Fields pulled from the lookup result. |
AlertLookup (built-in lookup)
A built-in alternative to DqlTableLookup, identified by builtInLookup: 'ALERTS_LOOKUP'. Resolved at runtime to a health-indicators lookup.
| Property | Type | Description |
|---|---|---|
|
| Discriminant. |
|
| Entity ID field the lookup matches against. |
|
| Filter expression distinguishing main-entity events from relation events. |
|
| See Health indicators. |
|
| Fields to expand. |
|
| Extra event fields to include. |
|
| Pre-filter expressions (without the leading |
DqlTableAdditionalCommand
| Property | Type | Description |
|---|---|---|
|
| Fields this command needs resolved first. |
|
| Fields this command produces. |
|
| The DQL command fragment (for example, |
|
| Experimental — appends the command after filters but before the limit clause. |
DqlTableColumn
| Property | Type | Description |
|---|---|---|
|
| Unique column ID. |
|
| Field accessor; must correspond to a field produced by the query. |
|
| Column header label. |
|
| Column type; affects alignment and default sort behavior. |
|
| Built-in cell renderer configuration. See below. |
|
| Width sizing strategy. |
|
| Width value paired with |
|
| Minimum width in pixels. |
|
| Whether the column can be sorted. |
|
| First click sorts descending instead of ascending. |
|
| Overrides for how the column is sorted. |
|
| Default columns can't be hidden via column visibility settings. |
|
| Perspectives in which this column is visible. |
|
| Pairs with another column of the same |
|
| Loads cell data only when the cell scrolls into view. |
|
| Excludes the column from downloads even if visible. |
|
| Adds a line-wrap toggle to the column header. |
|
| Tooltip text for a header info button. |
|
|
BuiltInColumn
A reference to a pre-configured runtime column, usable in columns alongside custom DqlTableColumn entries. The available built-in columns are health columns — they surface health indicator data alongside your table rows without requiring manual column configuration:
{ "builtInColumn": "HEALTH_ALERTS_COLUMN" }
| Literal | Description |
|---|---|
| Health column that shows Davis health alert indicators for each row's entity. |
| Health column that shows alerts not mapped to health alert indicators configuration. |
An optional overrides object (displayName, perspectives, defaultColumn, widthType, widthValue) customizes the built-in column without fully replacing it.
CellRenderer
A discriminated union on type. Set cellRenderer: { "type": "<name>", ...params } on a column to activate a built-in renderer. Renderers with no configuration fields accept a plain { "type": "..." } object.
type | Description | Expected cell data |
|---|---|---|
| Renders an array of values. |
|
| Renders a problem count badge. |
|
| Renders a vulnerability count badge. |
|
| Renders an alert count badge. |
|
| Renders Davis health alert indicator chips. | Health indicator payload |
| Renders custom alert indicator chips. | Custom alert payload |
| Overlays warning/critical health icons on top of another renderer. | Value accepted by the inner |
| Renders an SLO breach count. |
|
| Renders the formatted duration between two timestamps. |
|
| Renders and formats CPU millicores. |
|
| Converts bytes to human-readable units (KiB, MiB, …). |
|
| Formats a 0–1 fraction as a percentage. |
|
| Renders a 0–1 fraction as a progress bar with label. |
|
| Renders a 0–1 fraction as a meter bar. |
|
| Renders a count with a rate unit suffix (for example, |
|
| Renders a number with a Strato unit (for example, |
|
| Formats a timestamp as date and time. |
|
| Formats a numeric duration with the appropriate time unit. |
|
| Renders a sparkline alongside a scalar value (v1). |
|
| Renders a sparkline alongside a scalar value (v2). |
|
| Renders a list of owner chips. |
|
| Renders a clickable entity name; supports details, intent, or text modes. | Entity object ( |
| Renders "Just now" for recent timestamps, exact time otherwise. |
|
| Extracts and renders the value matching a tag key from a tag array. |
|
entity parameters
| Parameter | Type | Description |
|---|---|---|
|
| How the entity name navigates on click. |
|
| Minutes after |
|
| Stack entity name and extra info vertically. |
|
| Pathname for opening entity details in a new tab. |
|
| Search param key for the entity ID (for example, |
healthValue parameters
| Parameter | Type | Description |
|---|---|---|
|
| Renderer applied to the value itself. |
|
| Row field containing health indicator data. |
|
| Alert group to match against. |
|
| Display name for the alert. |
duration parameters
| Parameter | Type | Description |
|---|---|---|
|
| Round to seconds instead of milliseconds. |
meterBar parameters
| Parameter | Type | Description |
|---|---|---|
|
| Tooltip label shown on hover. |
countPerUnit parameters
| Parameter | Type | Description |
|---|---|---|
|
| Unit string appended as a rate suffix. |
unitRenderer / unit parameters
| Parameter | Type | Description |
|---|---|---|
|
| Strato unit identifier (for example, |
|
| Abbreviate the unit label. |
|
| Maximum decimal places. |
|
| Minimum decimal places. |
|
| Additional suffix appended after the unit. |
microChart / microChartV2 parameters
| Parameter | Type | Description |
|---|---|---|
|
| Sparkline style. |
|
| Hex color or Strato design token. |
|
| Show or hide the sparkline. |
|
| Formatter for the scalar value. |
|
| CSS width of the value area. |
|
| Y-axis bounds. |
time parameters
| Parameter | Type | Description |
|---|---|---|
|
| Input time unit. |
lastSeen / lastUpdated parameters
| Parameter | Type | Description |
|---|---|---|
|
| Minutes before switching from "Just now" to an exact timestamp. |
tag parameters
| Parameter | Type | Description |
|---|---|---|
|
| Tag key whose value to extract and display. |
DqlTableGroupingConfig
| Property | Type | Description |
|---|---|---|
|
| Fields grouped by default. |
|
| Fields the user can group by, optionally organized into named groups. |
|
| Aggregation function per numeric field ( |
|
| Whether grouped rows can be expanded to show underlying records. |
|
| Enables expansion of grouping rows (requires expandable rows to be configured). |
DqlTablePerspective
| Property | Type | Description |
|---|---|---|
|
| Unique perspective name. |
|
| Label shown to the user. |
|
| Description text. |
|
| Sort applied when the perspective is selected. |
RowThreshold
Serializable row-highlighting rules. A threshold is a single rule or a combined set of rules sharing one display variant — 'pill' (with a color) or 'highlight' (with backgroundColor/color). Each rule compares a field value with a comparator, optionally through an accessor.
Action unions
Action arrays accept both BuiltInAction<T> references ({ "builtInAction": "..." }) and full IntentAction objects. See Elements overview.
Providing an action array in the document overrides the default rendering for that slot — the defaults are not merged in. If you want to keep the default actions, every default action must be listed explicitly alongside your custom ones.
| Type | Used in | Built-in literals |
|---|---|---|
|
|
|
|
|
|
|
| none — intent actions only |
| per-column actions | none — intent actions only |
|
| none — intent actions only |
Example
{"type": "dql-table","id": "hosts-table","title": "Hosts","dqlQuery": {"idField": "id","query": "smartscapeNodes \"HOST\"","lookups": [{"query": "timeseries cpu = avg(dt.host.cpu.usage), by: { dt.entity.host }","sourceField": "id","lookupField": "dt.entity.host","fields": ["cpu"]},{"builtInLookup": "ALERTS_LOOKUP","filterExpression": "in(smartscape.affected_entity_types, \"HOST\")","additionalFields": []}]},"alertGroups": [{"groupName": "High CPU","alerts": [{"displayName": "CPU saturation","matchConditions": { "event.name": ["High CPU usage"] }}]}],"columns": [{ "id": "name", "field": "name", "displayName": "Name", "type": "text" },{"id": "cpu","field": "cpu","displayName": "CPU usage","cellRenderer": { "type": "microChartV2", "variant": "area" }},{ "builtInColumn": "HEALTH_ALERTS_COLUMN" }]}
See also
ExtensionsInfrastructure Observability