query_dashboard_visual
Query an existing dashboard visual with governed filters and compact analytical output
Machine-readable: focused JSON · complete manifest
Contract
| Property | Value |
|---|---|
| Authorization | RESOURCE_READ |
| Effect | read |
| Operation | queryDashboardVisualData |
| Tags | dashboard, visual, query |
| Defaults | {"limit":50} |
| MCP annotations | read-only, idempotent, non-destructive, closed-world |
Input schema
{
"additionalProperties": false,
"properties": {
"dashboard": {
"description": "Stable dashboard resource ID to query.",
"maxLength": 200,
"minLength": 1,
"pattern": "^[A-Za-z0-9][A-Za-z0-9_.:-]*$",
"type": "string"
},
"limit": {
"maximum": 50,
"minimum": 1,
"type": "integer"
},
"page": {
"type": "string"
},
"pageToken": {
"maxLength": 2048,
"minLength": 1,
"type": "string"
},
"visual": {
"type": "string"
}
},
"required": [
"dashboard",
"page",
"visual"
],
"type": "object"
}
Output schema
{
"additionalProperties": false,
"properties": {
"appliedFilters": {
"additionalProperties": false,
"properties": {
"controls": {
"additionalProperties": {
"oneOf": [
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"options": {
"oneOf": [
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"dataset": {
"maxLength": 128,
"minLength": 1,
"pattern": "^[A-Za-z_][A-Za-z0-9_-]*$",
"type": "string"
},
"dependsOn": {
"items": {
"maxLength": 128,
"minLength": 1,
"pattern": "^[A-Za-z_][A-Za-z0-9_-]*$",
"type": "string"
},
"type": "array"
},
"includeNull": {
"type": "boolean"
},
"limit": {
"type": "integer"
},
"type": {
"enum": [
"distinct"
],
"type": "string"
}
},
"required": [
"dataset",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"static"
],
"type": "string"
},
"values": {
"items": {
"additionalProperties": false,
"properties": {
"label": {
"type": "string"
},
"value": {
"oneOf": [
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"string"
],
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"boolean"
],
"type": "string"
},
"value": {
"type": "boolean"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"integer"
],
"type": "string"
},
"value": {
"description": "Precision-safe integer representation.",
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"decimal"
],
"type": "string"
},
"value": {
"description": "Canonical decimal representation.",
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"date"
],
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"timestamp"
],
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
}
]
}
},
"required": [
"label",
"value"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"type",
"values"
],
"type": "object"
}
]
},
"type": {
"enum": [
"singleSelect"
],
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"maxSelectedValues": {
"type": "integer"
},
"options": {
"oneOf": [
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"dataset": {
"maxLength": 128,
"minLength": 1,
"pattern": "^[A-Za-z_][A-Za-z0-9_-]*$",
"type": "string"
},
"dependsOn": {
"items": {
"maxLength": 128,
"minLength": 1,
"pattern": "^[A-Za-z_][A-Za-z0-9_-]*$",
"type": "string"
},
"type": "array"
},
"includeNull": {
"type": "boolean"
},
"limit": {
"type": "integer"
},
"type": {
"enum": [
"distinct"
],
"type": "string"
}
},
"required": [
"dataset",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"static"
],
"type": "string"
},
"values": {
"items": {
"additionalProperties": false,
"properties": {
"label": {
"type": "string"
},
"value": {
"oneOf": [
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"string"
],
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"boolean"
],
"type": "string"
},
"value": {
"type": "boolean"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"integer"
],
"type": "string"
},
"value": {
"description": "Precision-safe integer representation.",
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"decimal"
],
"type": "string"
},
"value": {
"description": "Canonical decimal representation.",
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"date"
],
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"timestamp"
],
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"type",
"value"
],
"type": "object"
}
]
}
},
"required": [
"label",
"value"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"type",
"values"
],
"type": "object"
}
]
},
"type": {
"enum": [
"multiSelect"
],
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"text"
],
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"numericRange"
],
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"dateRange"
],
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"allOf": [
{
"properties": {
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
],
"properties": {
"type": {
"enum": [
"relativePeriod"
],
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
]
},
"type": "object"
},
"selections": {
"items": {
"additionalProperties": {},
"type": "object"
},
"type": "array"
},
"spatialSelections": {
"items": {
"additionalProperties": {},
"type": "object"
},
"type": "array"
}
},
"required": [
"controls",
"selections",
"spatialSelections"
],
"type": "object"
},
"columns": {
"items": {
"additionalProperties": false,
"properties": {
"dataType": {
"enum": [
"string",
"boolean",
"integer",
"decimal",
"temporal",
"date",
"geographic"
],
"type": "string"
},
"format": {
"additionalProperties": {},
"type": "object"
},
"grain": {
"type": "string"
},
"id": {
"type": "string"
},
"label": {
"type": "string"
},
"nullable": {
"type": "boolean"
},
"role": {
"enum": [
"dimension",
"metric",
"metadata",
"identity"
],
"type": "string"
},
"sourceRef": {
"type": "string"
}
},
"required": [
"dataType",
"id",
"label",
"nullable",
"role"
],
"type": "object"
},
"type": "array"
},
"completeness": {
"additionalProperties": false,
"properties": {
"availableRows": {
"type": "integer"
},
"cardinality": {
"enum": [
"unknown",
"lower_bound",
"estimated",
"exact"
],
"type": "string"
},
"cardinalityCount": {
"type": "integer"
},
"returnedRows": {
"type": "integer"
},
"state": {
"enum": [
"complete",
"truncated",
"partial",
"empty"
],
"type": "string"
}
},
"required": [
"cardinality",
"returnedRows",
"state"
],
"type": "object"
},
"datasetId": {
"type": "string"
},
"diagnostics": {
"items": {
"additionalProperties": false,
"properties": {
"code": {
"type": "string"
},
"fieldId": {
"type": "string"
},
"message": {
"type": "string"
},
"severity": {
"enum": [
"info",
"warning",
"error"
],
"type": "string"
}
},
"required": [
"code",
"message",
"severity"
],
"type": "object"
},
"type": "array"
},
"freshness": {
"additionalProperties": false,
"properties": {
"lastSuccessfulRefreshAt": {
"description": "Completion time of the last successful publish or refresh. This is not an upstream event-time watermark.",
"type": "string"
},
"servingStateId": {
"description": "Serving state that produced the successful data version.",
"type": "string"
},
"snapshotId": {
"description": "DuckLake snapshot ID recorded for the successful data version.",
"type": "string"
},
"source": {
"description": "Whether the data version came from publish or refresh.",
"enum": [
"publish",
"refresh"
],
"type": "string"
},
"status": {
"description": "current when the successful data version belongs to the queried serving snapshot; stale otherwise.",
"enum": [
"current",
"stale"
],
"type": "string"
}
},
"required": [
"lastSuccessfulRefreshAt",
"servingStateId",
"snapshotId",
"source",
"status"
],
"type": "object"
},
"hasMore": {
"type": "boolean"
},
"mark": {
"type": "string"
},
"nextCursor": {
"type": "string"
},
"queryId": {
"type": "string"
},
"rows": {
"items": {
"items": {},
"type": "array"
},
"type": "array"
},
"servingSnapshot": {
"type": "string"
},
"status": {
"additionalProperties": false,
"properties": {
"kind": {
"enum": [
"idle",
"loading",
"ready",
"no_data",
"partial",
"error"
],
"type": "string"
},
"message": {
"type": "string"
}
},
"required": [
"kind"
],
"type": "object"
},
"title": {
"type": "string"
},
"type": {
"type": "string"
},
"visualId": {
"type": "string"
}
},
"required": [
"appliedFilters",
"columns",
"completeness",
"datasetId",
"diagnostics",
"hasMore",
"queryId",
"rows",
"servingSnapshot",
"status",
"title",
"type",
"visualId"
],
"type": "object"
}