invalid_analytics_table

err:user:bad_request:invalid_analytics_table

Example

{
  "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

SELECT * FROM system.tables

SELECT * FROM key_verifications_v1
WHERE time >= now() - INTERVAL 7 DAY

2. Fix Typos in Table Names

SELECT * FROM key_verification
WHERE time >= now() - INTERVAL 1 DAY

SELECT * FROM key_verifications_v1
WHERE time >= now() - INTERVAL 1 DAY

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

Getting Started

Platform

Build & Deploy

Networking

Observability

CLI

Security

Keyspaces

AI Code Gen

Audit Logs

CLI

Errors

invalid_analytics_table

What Happened?

How to Fix It

1. Use the Correct Table Name

2. Fix Typos in Table Names

Available Tables

​What Happened?

​How to Fix It

​1. Use the Correct Table Name

​2. Fix Typos in Table Names

​Available Tables

What Happened?

How to Fix It

1. Use the Correct Table Name

2. Fix Typos in Table Names

Available Tables