Error
A valid request URL is required to generate request examples{
"results": {
"counts": {
"warehouseTimeMsLast7Days": 123,
"total": 123,
"windows": {
"lastFewMinutes": 123,
"lastHour": 123,
"last24Hours": 123,
"last7Days": 123,
"last30Days": 123
},
"triggers": {
"interactive": 123,
"apps": 123,
"scheduled": 123
}
},
"data": [
{
"erroredAt": "2023-11-07T05:31:56Z",
"resultsUpdatedAt": "2023-11-07T05:31:56Z",
"processingStartedAt": "2023-11-07T05:31:56Z",
"resultsExpiresAt": "2023-11-07T05:31:56Z",
"cacheHit": true,
"warehouseExecutionTimeMs": 123,
"totalRowCount": 123,
"compiledSql": "<string>",
"dashboardUuid": "<string>",
"dashboardName": "<string>",
"savedSqlUuid": "<string>",
"chartUuid": "<string>",
"chartName": "<string>",
"requestParameters": {
"query": {
"filters": {
"tableCalculations": "<unknown>",
"metrics": "<unknown>",
"dimensions": "<unknown>"
},
"exploreName": "<string>",
"dimensions": [
"<string>"
],
"metrics": [
"<string>"
],
"sorts": [
{
"descending": true,
"fieldId": "<string>",
"pivotValues": [
{
"value": "<string>",
"reference": "<string>"
}
],
"nullsFirst": true
}
],
"limit": 123,
"tableCalculations": [
{
"displayName": "<string>",
"name": "<string>",
"sql": "<string>",
"format": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"index": 123
}
],
"additionalMetrics": [
{
"sql": "<string>",
"table": "<string>",
"name": "<string>",
"label": "<string>",
"description": "<string>",
"hidden": true,
"round": 123,
"index": 123,
"filters": [
{
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"baseDimensionName": "<string>",
"baseMetricName": "<string>",
"uuid": "<string>",
"percentile": 123,
"distinctKeys": [
"<string>"
],
"formatOptions": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"generationType": "periodOverPeriod",
"baseMetricId": "<string>",
"timeDimensionId": "<string>",
"periodOffset": 123
}
],
"customDimensions": [
{
"id": "<string>",
"name": "<string>",
"table": "<string>",
"type": "bin",
"dimensionId": "<string>",
"binType": "fixed_number",
"binNumber": 123
}
],
"metricOverrides": {},
"dimensionOverrides": {},
"timezone": "<string>",
"pivotDimensions": [
"<string>"
],
"metadata": {
"hasADateDimension": {}
},
"dateZoom": {
"xAxisFieldId": "<string>"
}
},
"parameters": {},
"usePreAggregateCache": true,
"invalidateCache": true,
"dashboardFilters": {
"tableCalculations": [
{
"id": "<string>",
"target": {
"tableName": "<string>",
"fieldId": "<string>",
"isSqlColumn": true
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true,
"lockedTabUuids": [
"<string>"
],
"requiredGroupId": "<string>",
"singleValue": true,
"label": "<string>",
"tileTargets": {}
}
],
"metrics": [
{
"id": "<string>",
"target": {
"tableName": "<string>",
"fieldId": "<string>",
"isSqlColumn": true
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true,
"lockedTabUuids": [
"<string>"
],
"requiredGroupId": "<string>",
"singleValue": true,
"label": "<string>",
"tileTargets": {}
}
],
"dimensions": [
{
"id": "<string>",
"target": {
"tableName": "<string>",
"fieldId": "<string>",
"isSqlColumn": true
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true,
"lockedTabUuids": [
"<string>"
],
"requiredGroupId": "<string>",
"singleValue": true,
"label": "<string>",
"tileTargets": {}
}
]
},
"pivotConfiguration": {
"valuesColumns": [
{
"reference": "<string>"
}
],
"pivotColumnsOrder": [
{
"reference": "<string>"
}
],
"passthroughDimensions": [
{
"reference": "<string>"
}
],
"sortOnlyDimensions": [
{
"reference": "<string>"
}
],
"sortOnlyColumns": [
{
"reference": "<string>"
}
],
"metricsAsRows": true,
"sortBy": [
{
"reference": "<string>",
"pivotValues": [
{
"value": "<string>",
"reference": "<string>"
}
],
"nullsFirst": true
}
],
"groupByColumns": [
{
"reference": "<string>"
}
],
"indexColumn": {
"reference": "<string>"
}
},
"dateZoom": {
"xAxisFieldId": "<string>"
}
},
"metricQuery": {
"tableCalculations": [
{
"displayName": "<string>",
"name": "<string>",
"sql": "<string>",
"format": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"index": 123
}
],
"limit": 123,
"sorts": [
{
"descending": true,
"fieldId": "<string>",
"pivotValues": [
{
"value": "<string>",
"reference": "<string>"
}
],
"nullsFirst": true
}
],
"filters": {
"tableCalculations": {
"or": [
{
"id": "<string>",
"target": {
"fieldId": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"id": "<string>"
},
"metrics": {
"or": [
{
"id": "<string>",
"target": {
"fieldId": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"id": "<string>"
},
"dimensions": {
"or": [
{
"id": "<string>",
"target": {
"fieldId": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"id": "<string>"
}
},
"metrics": [
"<string>"
],
"dimensions": [
"<string>"
],
"exploreName": "<string>",
"metadata": {
"hasADateDimension": {
"name": "<string>",
"label": "<string>",
"table": "<string>"
}
},
"pivotDimensions": [
"<string>"
],
"timezone": "<string>",
"dimensionOverrides": {},
"metricOverrides": {},
"customDimensions": [
{
"id": "<string>",
"name": "<string>",
"table": "<string>",
"type": "bin",
"dimensionId": "<string>",
"binType": "fixed_number",
"binNumber": 123
}
],
"additionalMetrics": [
{
"sql": "<string>",
"table": "<string>",
"name": "<string>",
"label": "<string>",
"description": "<string>",
"hidden": true,
"round": 123,
"index": 123,
"filters": [
{
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"baseDimensionName": "<string>",
"baseMetricName": "<string>",
"uuid": "<string>",
"percentile": 123,
"distinctKeys": [
"<string>"
],
"formatOptions": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"generationType": "periodOverPeriod",
"baseMetricId": "<string>",
"timeDimensionId": "<string>",
"periodOffset": 123
}
]
},
"exploreName": "<string>",
"error": "<string>",
"subline": "<string>",
"title": "<string>",
"projectUuid": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"queryUuid": "<string>"
}
],
"pagination": {
"page": 123,
"pageSize": 123,
"totalResults": 123,
"totalPageCount": 123
}
},
"status": "ok"
}{
"error": {
"name": "<string>",
"statusCode": 123,
"data": "<unknown>",
"message": "<string>"
},
"status": "error"
}v2
List my query history
Lists the requesting userās own query history for a project, newest first, with per-trigger and per-window counts.
Must stay declared before getAsyncQueryResults so the generated
/history route is matched before /{queryUuid}.
GET
/
api
/
v2
/
projects
/
{projectUuid}
/
query
/
history
Error
A valid request URL is required to generate request examples{
"results": {
"counts": {
"warehouseTimeMsLast7Days": 123,
"total": 123,
"windows": {
"lastFewMinutes": 123,
"lastHour": 123,
"last24Hours": 123,
"last7Days": 123,
"last30Days": 123
},
"triggers": {
"interactive": 123,
"apps": 123,
"scheduled": 123
}
},
"data": [
{
"erroredAt": "2023-11-07T05:31:56Z",
"resultsUpdatedAt": "2023-11-07T05:31:56Z",
"processingStartedAt": "2023-11-07T05:31:56Z",
"resultsExpiresAt": "2023-11-07T05:31:56Z",
"cacheHit": true,
"warehouseExecutionTimeMs": 123,
"totalRowCount": 123,
"compiledSql": "<string>",
"dashboardUuid": "<string>",
"dashboardName": "<string>",
"savedSqlUuid": "<string>",
"chartUuid": "<string>",
"chartName": "<string>",
"requestParameters": {
"query": {
"filters": {
"tableCalculations": "<unknown>",
"metrics": "<unknown>",
"dimensions": "<unknown>"
},
"exploreName": "<string>",
"dimensions": [
"<string>"
],
"metrics": [
"<string>"
],
"sorts": [
{
"descending": true,
"fieldId": "<string>",
"pivotValues": [
{
"value": "<string>",
"reference": "<string>"
}
],
"nullsFirst": true
}
],
"limit": 123,
"tableCalculations": [
{
"displayName": "<string>",
"name": "<string>",
"sql": "<string>",
"format": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"index": 123
}
],
"additionalMetrics": [
{
"sql": "<string>",
"table": "<string>",
"name": "<string>",
"label": "<string>",
"description": "<string>",
"hidden": true,
"round": 123,
"index": 123,
"filters": [
{
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"baseDimensionName": "<string>",
"baseMetricName": "<string>",
"uuid": "<string>",
"percentile": 123,
"distinctKeys": [
"<string>"
],
"formatOptions": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"generationType": "periodOverPeriod",
"baseMetricId": "<string>",
"timeDimensionId": "<string>",
"periodOffset": 123
}
],
"customDimensions": [
{
"id": "<string>",
"name": "<string>",
"table": "<string>",
"type": "bin",
"dimensionId": "<string>",
"binType": "fixed_number",
"binNumber": 123
}
],
"metricOverrides": {},
"dimensionOverrides": {},
"timezone": "<string>",
"pivotDimensions": [
"<string>"
],
"metadata": {
"hasADateDimension": {}
},
"dateZoom": {
"xAxisFieldId": "<string>"
}
},
"parameters": {},
"usePreAggregateCache": true,
"invalidateCache": true,
"dashboardFilters": {
"tableCalculations": [
{
"id": "<string>",
"target": {
"tableName": "<string>",
"fieldId": "<string>",
"isSqlColumn": true
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true,
"lockedTabUuids": [
"<string>"
],
"requiredGroupId": "<string>",
"singleValue": true,
"label": "<string>",
"tileTargets": {}
}
],
"metrics": [
{
"id": "<string>",
"target": {
"tableName": "<string>",
"fieldId": "<string>",
"isSqlColumn": true
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true,
"lockedTabUuids": [
"<string>"
],
"requiredGroupId": "<string>",
"singleValue": true,
"label": "<string>",
"tileTargets": {}
}
],
"dimensions": [
{
"id": "<string>",
"target": {
"tableName": "<string>",
"fieldId": "<string>",
"isSqlColumn": true
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true,
"lockedTabUuids": [
"<string>"
],
"requiredGroupId": "<string>",
"singleValue": true,
"label": "<string>",
"tileTargets": {}
}
]
},
"pivotConfiguration": {
"valuesColumns": [
{
"reference": "<string>"
}
],
"pivotColumnsOrder": [
{
"reference": "<string>"
}
],
"passthroughDimensions": [
{
"reference": "<string>"
}
],
"sortOnlyDimensions": [
{
"reference": "<string>"
}
],
"sortOnlyColumns": [
{
"reference": "<string>"
}
],
"metricsAsRows": true,
"sortBy": [
{
"reference": "<string>",
"pivotValues": [
{
"value": "<string>",
"reference": "<string>"
}
],
"nullsFirst": true
}
],
"groupByColumns": [
{
"reference": "<string>"
}
],
"indexColumn": {
"reference": "<string>"
}
},
"dateZoom": {
"xAxisFieldId": "<string>"
}
},
"metricQuery": {
"tableCalculations": [
{
"displayName": "<string>",
"name": "<string>",
"sql": "<string>",
"format": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"index": 123
}
],
"limit": 123,
"sorts": [
{
"descending": true,
"fieldId": "<string>",
"pivotValues": [
{
"value": "<string>",
"reference": "<string>"
}
],
"nullsFirst": true
}
],
"filters": {
"tableCalculations": {
"or": [
{
"id": "<string>",
"target": {
"fieldId": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"id": "<string>"
},
"metrics": {
"or": [
{
"id": "<string>",
"target": {
"fieldId": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"id": "<string>"
},
"dimensions": {
"or": [
{
"id": "<string>",
"target": {
"fieldId": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"id": "<string>"
}
},
"metrics": [
"<string>"
],
"dimensions": [
"<string>"
],
"exploreName": "<string>",
"metadata": {
"hasADateDimension": {
"name": "<string>",
"label": "<string>",
"table": "<string>"
}
},
"pivotDimensions": [
"<string>"
],
"timezone": "<string>",
"dimensionOverrides": {},
"metricOverrides": {},
"customDimensions": [
{
"id": "<string>",
"name": "<string>",
"table": "<string>",
"type": "bin",
"dimensionId": "<string>",
"binType": "fixed_number",
"binNumber": 123
}
],
"additionalMetrics": [
{
"sql": "<string>",
"table": "<string>",
"name": "<string>",
"label": "<string>",
"description": "<string>",
"hidden": true,
"round": 123,
"index": 123,
"filters": [
{
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"includeNull": true,
"values": [
"<unknown>"
],
"settings": "<unknown>",
"disabled": true,
"required": true,
"caseSensitive": true
}
],
"baseDimensionName": "<string>",
"baseMetricName": "<string>",
"uuid": "<string>",
"percentile": 123,
"distinctKeys": [
"<string>"
],
"formatOptions": {
"round": 123,
"currency": "<string>",
"prefix": "<string>",
"suffix": "<string>",
"custom": "<string>"
},
"generationType": "periodOverPeriod",
"baseMetricId": "<string>",
"timeDimensionId": "<string>",
"periodOffset": 123
}
]
},
"exploreName": "<string>",
"error": "<string>",
"subline": "<string>",
"title": "<string>",
"projectUuid": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"queryUuid": "<string>"
}
],
"pagination": {
"page": 123,
"pageSize": 123,
"totalResults": 123,
"totalPageCount": 123
}
},
"status": "ok"
}{
"error": {
"name": "<string>",
"statusCode": 123,
"data": "<unknown>",
"message": "<string>"
},
"status": "error"
}Path Parameters
Query Parameters
Page number for pagination (starts at 1)
Number of results per page (default: 25, max: 100)
Filter by what triggered the run
User-facing grouping of QueryExecutionContext values by what triggered the
run: a person acting directly, an app surface loading many queries at once
(dashboards, embeds, data apps), or a schedule running in the background.
Available options:
interactive, apps, scheduled Filter by query language
Available options:
semantic, sql Filter by one or more statuses
Available options:
pending, queued, executing, expired, ready, error, cancelled Matches explore name, chart/dashboard name, fields and SQL
Restrict rows to one disjoint time window Time windows for the query history list, newest first. Windows are disjoint: "last hour" excludes the last few minutes, and so on. Anything older than 30 days is out of scope for the page.
Available options:
lastFewMinutes, lastHour, last24Hours, last7Days, last30Days Sort order; runtime flattens the windows into one sorted list
Available options:
createdAt, runtime Was this page helpful?
āI