Rest api on sql and job

How can I pull back more than 500 rows on the rest api post and get? I did:

POST /api/v3/sql

with a sql that returns over 10000 rows, but after getting that job id and do a get

GET /api/v3/job/{id}/results?offset={offset}&limit={limit}

I only have a result set of 500

The limit can’t be set higher then 500. However, you can repeatedly call the results endpoint by increasing the offset by the limit for each call until you’ve read all the data.

We on purpose limit to 500 at a time as asking for a lot of rows at once can lead to performance issues. If you need to fetch large result sets we recommend using jdbc/ODBC as those are much more performant for that.