Query

POST {{baseUrl}}/v1/orgs/self/queries

Make a SQL query to Rockset.

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

RESPONSES

status: OK

{"query_id":"aute al","collections":["sunt in ut ","voluptate Duis"],"stats":{"elapsed_time_ms":126,"throttled_time_micros":126},"warnings":["Excepteur","magna"],"query_errors":[{"type":"ResourceExceeded","message":"Too many rows","status_code":429},{"type":"ResourceExceeded","message":"Too many rows","status_code":429}],"column_fields":[{"name":"_id","type":"string"},{"name":"_id","type":"string"}]}