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

200

{
  "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>",
                "totalMode": "formula",
                "type": "number",
                "format": {
                  "type": "default",
                  "round": 123,
                  "separator": "default",
                  "currency": "<string>",
                  "compact": "auto",
                  "prefix": "<string>",
                  "suffix": "<string>",
                  "timeInterval": "RAW",
                  "custom": "<string>"
                },
                "index": 123
              }
            ],
            "additionalMetrics": [
              {
                "type": "percentile",
                "sql": "<string>",
                "table": "<string>",
                "name": "<string>",
                "label": "<string>",
                "description": "<string>",
                "hidden": true,
                "round": 123,
                "compact": "auto",
                "format": "km",
                "separator": "default",
                "index": 123,
                "filters": [
                  {
                    "operator": "isNull",
                    "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": {
                  "type": "default",
                  "round": 123,
                  "separator": "default",
                  "currency": "<string>",
                  "compact": "auto",
                  "prefix": "<string>",
                  "suffix": "<string>",
                  "timeInterval": "RAW",
                  "custom": "<string>"
                },
                "generationType": "periodOverPeriod",
                "baseMetricId": "<string>",
                "timeDimensionId": "<string>",
                "granularity": "RAW",
                "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>",
              "granularity": "Second"
            }
          },
          "parameters": {},
          "usePreAggregateCache": true,
          "invalidateCache": true,
          "context": "dashboardView",
          "dashboardFilters": {
            "tableCalculations": [
              {
                "operator": "isNull",
                "id": "<string>",
                "target": {
                  "tableName": "<string>",
                  "fieldId": "<string>",
                  "fallbackType": "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": [
              {
                "operator": "isNull",
                "id": "<string>",
                "target": {
                  "tableName": "<string>",
                  "fieldId": "<string>",
                  "fallbackType": "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": [
              {
                "operator": "isNull",
                "id": "<string>",
                "target": {
                  "tableName": "<string>",
                  "fieldId": "<string>",
                  "fallbackType": "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": [
              {
                "aggregation": "sum",
                "reference": "<string>"
              }
            ],
            "pivotColumnsOrder": [
              {
                "reference": "<string>"
              }
            ],
            "passthroughDimensions": [
              {
                "reference": "<string>"
              }
            ],
            "sortOnlyDimensions": [
              {
                "reference": "<string>"
              }
            ],
            "sortOnlyColumns": [
              {
                "aggregation": "sum",
                "reference": "<string>"
              }
            ],
            "metricsAsRows": true,
            "sortBy": [
              {
                "direction": "ASC",
                "reference": "<string>",
                "pivotValues": [
                  {
                    "value": "<string>",
                    "reference": "<string>"
                  }
                ],
                "nullsFirst": true
              }
            ],
            "groupByColumns": [
              {
                "reference": "<string>"
              }
            ],
            "indexColumn": {
              "type": "time",
              "reference": "<string>"
            }
          },
          "dateZoom": {
            "xAxisFieldId": "<string>",
            "granularity": "Second"
          }
        },
        "metricQuery": {
          "tableCalculations": [
            {
              "displayName": "<string>",
              "name": "<string>",
              "sql": "<string>",
              "totalMode": "formula",
              "type": "number",
              "format": {
                "type": "default",
                "round": 123,
                "separator": "default",
                "currency": "<string>",
                "compact": "auto",
                "prefix": "<string>",
                "suffix": "<string>",
                "timeInterval": "RAW",
                "custom": "<string>"
              },
              "index": 123
            }
          ],
          "limit": 123,
          "sorts": [
            {
              "descending": true,
              "fieldId": "<string>",
              "pivotValues": [
                {
                  "value": "<string>",
                  "reference": "<string>"
                }
              ],
              "nullsFirst": true
            }
          ],
          "filters": {
            "tableCalculations": {
              "or": [
                {
                  "operator": "isNull",
                  "id": "<string>",
                  "target": {
                    "fieldId": "<string>"
                  },
                  "includeNull": true,
                  "values": [
                    "<unknown>"
                  ],
                  "settings": "<unknown>",
                  "disabled": true,
                  "required": true,
                  "caseSensitive": true
                }
              ],
              "id": "<string>"
            },
            "metrics": {
              "or": [
                {
                  "operator": "isNull",
                  "id": "<string>",
                  "target": {
                    "fieldId": "<string>"
                  },
                  "includeNull": true,
                  "values": [
                    "<unknown>"
                  ],
                  "settings": "<unknown>",
                  "disabled": true,
                  "required": true,
                  "caseSensitive": true
                }
              ],
              "id": "<string>"
            },
            "dimensions": {
              "or": [
                {
                  "operator": "isNull",
                  "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": [
            {
              "type": "percentile",
              "sql": "<string>",
              "table": "<string>",
              "name": "<string>",
              "label": "<string>",
              "description": "<string>",
              "hidden": true,
              "round": 123,
              "compact": "auto",
              "format": "km",
              "separator": "default",
              "index": 123,
              "filters": [
                {
                  "operator": "isNull",
                  "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": {
                "type": "default",
                "round": 123,
                "separator": "default",
                "currency": "<string>",
                "compact": "auto",
                "prefix": "<string>",
                "suffix": "<string>",
                "timeInterval": "RAW",
                "custom": "<string>"
              },
              "generationType": "periodOverPeriod",
              "baseMetricId": "<string>",
              "timeDimensionId": "<string>",
              "granularity": "RAW",
              "periodOffset": 123
            }
          ]
        },
        "exploreName": "<string>",
        "error": "<string>",
        "subline": "<string>",
        "title": "<string>",
        "status": "pending",
        "language": "semantic",
        "trigger": "interactive",
        "context": "dashboardView",
        "projectUuid": "<string>",
        "createdAt": "2023-11-07T05:31:56Z",
        "queryUuid": "<string>"
      }
    ],
    "pagination": {
      "page": 123,
      "pageSize": 123,
      "totalResults": 123,
      "totalPageCount": 123
    }
  },
  "status": "ok"
}

Path Parameters

projectUuid · string · required

Query Parameters

page · number<double> · default: 1

Page number for pagination (starts at 1)

pageSize · number<double> · default: 25

Number of results per page (default: 25, max: 100)

trigger · enum<string>

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

language · enum<string>

Filter by query language

Available options: semantic, sql

status · enum<string>[]

Filter by one or more statuses

Available options: pending, queued, executing, expired, ready, error, cancelled

search · string

Matches explore name, chart/dashboard name, fields and SQL

window · enum<string>

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

sortBy · enum<string>

Sort order; runtime flattens the windows into one sorted list

Available options: createdAt, runtime

Response

200

application/json

Success

results · object · required

Show child attributes

status · enum<string> · required

Available options: ok