Looks like this bug has already been reported in Pagination query does not return as requested records
I tried the suggested fix which was to delete the metadata and refresh it, but it didn’t help…
Basically the Dremio UI returns back 1567 rows, but the REST API SQL calls returns back 1125.
Seems there is some bug that is truncating the rows between 1000 and 1500.