Skip to main content
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. For security, only specific analytics tables are accessible:
  • key_verifications_v1 - Raw key verification events
  • key_verifications_per_minute_v1 - Minute-level aggregates
  • key_verifications_per_hour_v1 - Hour-level aggregates
  • key_verifications_per_day_v1 - Day-level aggregates
  • key_verifications_per_month_v1 - Month-level aggregates
System tables (like system.*) and other database tables are blocked.

​
How to Fix It

​
1. Use the Correct Table Name

SELECT * FROM system.tables

​
2. Fix Typos in Table Names

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

​
Available Tables

Table NameDescription
key_verifications_v1Raw verification events
key_verifications_per_minute_v1Minute-level aggregates
key_verifications_per_hour_v1Hour-level aggregates
key_verifications_per_day_v1Day-level aggregates
key_verifications_per_month_v1Month-level aggregates