invalid_analytics_query

{
  "meta": {
    "requestId": "req_4dgzrNP3Je5mU1tD"
  },
  "error": {
    "detail": "Syntax error: Expected identifier, got 'FROM' at position 15",
    "status": 400,
    "title": "Bad Request",
    "type": "https://unkey.com/docs/errors/user/bad_request/invalid_analytics_query"
  }
}

​

What Happened?

• Missing or extra commas
• Unclosed quotes or parentheses
• Typos in SQL keywords
• Invalid column or table names

​

How to Fix It

​

1. Check for Missing Commas

SELECT
  key_space_id
  COUNT(*) as total
FROM key_verifications_v1

SELECT
  key_space_id,
  COUNT(*) as total
FROM key_verifications_v1

​

2. Match Quotes and Parentheses

SELECT key_space_id, outcome
FROM key_verifications_v1
WHERE key_space_id = 'ks_123

SELECT key_space_id, outcome
FROM key_verifications_v1
WHERE key_space_id = 'ks_123'

​

3. Use Correct SQL Keywords

SELCT time, outcome
FROM key_verifications_v1

SELECT time, outcome
FROM key_verifications_v1

​

4. Verify Column Names

-- ✓ Valid columns
SELECT time, key_space_id, outcome, key_id
FROM key_verifications_v1
WHERE time >= now() - INTERVAL 7 DAY

​

Need Help?

1. Check the error message - It usually tells you exactly where the problem is
2. Test incrementally - Start with a simple query like SELECT time, outcome FROM table_name LIMIT 10 and add complexity step by step
3. Use a SQL validator - Many online tools can help spot syntax errors
4. Check the schema - Refer to the Schema Reference for valid column names