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
SELECTor aWITHstatement. 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..."
}
}