Validate Query
POST {{baseUrl}}/v1/orgs/self/queries/validations?parameters=false
Validate a SQL query with Rockset's parser and planner.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
parameters | boolean |
Request Body
{"sql"=>{"query"=>"SELECT * FROM foo where _id = :_id", "parameters"=>[{"name"=>"_id", "type"=>"string", "value"=>"85beb391"}, {"name"=>"_id", "type"=>"string", "value"=>"85beb391"}], "default_row_limit"=>73595355, "generate_warnings"=>false, "profiling_enabled"=>false}}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string |
RESPONSES
status: OK
{"collections":["sunt dolor eu ","mollit incididunt Ut Lorem"],"name":["ipsum occaecat ea officia nulla","cupidatat"],"parameters":["cillum consectetur et reprehenderit dolor","minim dolor Lorem elit velit"]}