I have used the REST API for Dremio to query from a node.js application using Kysely. When building the Kysely driver, I had to be aware of one main limitation of Dremio… from the REST API, you can only get 500 records per response to each request. You have to continue to send the same query with different limit and offset values shifted up by 500 until the response does not have 500 records.
1 Like