FullVision
Errors

invalid_sql

400 — SQL syntax error or forbidden statement

What happened

FullVision refused the SQL (Structured Query Language) statement you sent.

Why it usually happens

Either the statement was not a read — only SELECT and WITH are accepted — or the query failed to parse, or it named a column or table that does not exist.

How to fix

  • Write the query as a SELECT or a WITH statement. Statements that modify data are never accepted.
  • Read message — it carries the parse error when there is one.
  • Check every column and table name in the query against the shape you expect.

Envelope

{
  "error": {
    "code": "invalid_sql",
    "message": "SQL must be a SELECT or WITH statement.",
    "param": "body.sql",
    "doc_url": "https://docs.fullvision.io/errors/invalid_sql",
    "trace_id": "tr_01HXYZ..."
  }
}

On this page