Get query results

GET 
/queries/:queryid/results

Returns the result rows of a query. The query must have reached SUCCEEDED, otherwise the request is rejected with GE-1095, and the caller must be the user who submitted it.

This operation is a preview, not a full export: the backend caps the response at 51 rows and there are no pagination parameters. Use ResultsDownloadLink, or GET /queries/{queryid}/results/download, to retrieve the complete result file.

Statements that produce no result set (CREATE, MERGE INTO, VACUUM) return a synthetic single-column result whose Header is ["Message"] and whose single row carries the confirmation text, with no ResultsDownloadLink.

Note that an unknown query id is reported as HTTP 400 with IPV-1002, not 404.

Request

Responses

200

Result preview, capped at 51 rows. TotalNumRows is present on the Redshift path only.

Response Headers

Access-Control-Allow-Origin
Access-Control-Allow-Methods
Access-Control-Allow-Headers

400

Input validation or authorization failure. Body is {"Message": " - "}. Codes: IPV-1002 (query id not found), AUTH-1010 (the query belongs to a different user), GE-1095 (the query has not reached SUCCEEDED), AUTH-1001 / AUTH-1030 / GE-1060 (authorization).

Response Headers

Access-Control-Allow-Origin
Access-Control-Allow-Methods
Access-Control-Allow-Headers

500

Backend failure, including the case where the stored result location is missing for a successful query (GE-1034). Body is {"Message": " - "}.

Response Headers

Access-Control-Allow-Origin
Access-Control-Allow-Methods
Access-Control-Allow-Headers