> ## Documentation Index
> Fetch the complete documentation index at: https://unkey-eng-3082-add-portal-config-crud-api-endpoints-v2portal.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# invalid_analytics_table

> Your analytics query references a table that does not exist or is not accessible in Unkey. Check available tables in the schema reference.

<Danger>`err:user:bad_request:invalid_analytics_table`</Danger>

```json Example theme={"theme":"kanagawa-wave"}
{
  "meta": {
    "requestId": "req_4dgzrNP3Je5mU1tD"
  },
  "error": {
    "detail": "Access to table 'system.tables' is not allowed",
    "status": 400,
    "title": "Bad Request",
    "type": "https://unkey.com/docs/errors/user/bad_request/invalid_analytics_table"
  }
}
```

## What Happened?

Your query tried to access a table that either doesn't exist or isn't allowed for security reasons.

## How to Fix It

### 1. Use the Correct Table Name

<CodeGroup>
  ```sql Wrong - System table theme={"theme":"kanagawa-wave"}
  SELECT * FROM system.tables
  ```

  ```sql Correct - Analytics table theme={"theme":"kanagawa-wave"}
  SELECT * FROM key_verifications_v1
  WHERE time >= now() - INTERVAL 7 DAY
  ```
</CodeGroup>

### 2. Fix Typos in Table Names

<CodeGroup>
  ```sql Wrong - Typo theme={"theme":"kanagawa-wave"}
  SELECT * FROM key_verification
  WHERE time >= now() - INTERVAL 1 DAY
  ```

  ```sql Correct theme={"theme":"kanagawa-wave"}
  SELECT * FROM key_verifications_v1
  WHERE time >= now() - INTERVAL 1 DAY
  ```
</CodeGroup>

## Available Tables

| Endpoint                       | Table Name                        | Description                      |
| ------------------------------ | --------------------------------- | -------------------------------- |
| `analytics.getVerifications`   | `key_verifications_v1`            | Raw verification events          |
| `analytics.getVerifications`   | `key_verifications_per_minute_v1` | Minute-level aggregates          |
| `analytics.getVerifications`   | `key_verifications_per_hour_v1`   | Hour-level aggregates            |
| `analytics.getVerifications`   | `key_verifications_per_day_v1`    | Day-level aggregates             |
| `analytics.getVerifications`   | `key_verifications_per_month_v1`  | Month-level aggregates           |
| `analytics.getRatelimits`      | `ratelimits_v1`                   | Raw rate limit events            |
| `analytics.getRatelimits`      | `ratelimits_per_minute_v1`        | Minute-level aggregates          |
| `analytics.getRatelimits`      | `ratelimits_per_hour_v1`          | Hour-level aggregates            |
| `analytics.getRatelimits`      | `ratelimits_per_day_v1`           | Day-level aggregates             |
| `analytics.getRatelimits`      | `ratelimits_per_month_v1`         | Month-level aggregates           |
| `analytics.getRuntimeLogs`     | `runtime_logs_v1`                 | Runtime logs of your deployments |
| `analytics.getGatewayRequests` | `gateway_requests_v1`             | Raw gateway requests             |