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?#

Your SQL query has a syntax error! The query parser found invalid SQL syntax that prevents it from being executed.

Common causes include:

• 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 totalFROM key_verifications_v1

2. Match Quotes and Parentheses#

SELECT key_space_id, outcomeFROM key_verifications_v1WHERE key_space_id = 'ks_123

3. Use Correct SQL Keywords#

SELCT time, outcomeFROM key_verifications_v1

4. Verify Column Names#

Make sure you're using valid column names from your analytics tables:

-- ✓ Valid columnsSELECT time, key_space_id, outcome, key_idFROM key_verifications_v1WHERE time >= now() - INTERVAL 7 DAY

Need Help?#

If you're stuck with a syntax error:

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