Retrieve job results via flight after checking completed with API

1

Hello,

I would like to know if by any means,
one could send a query by api
check regularly its status by api
when it’s completed download results through odbc or arrow flight using the job id as reference

(I already know how to retrieve results with api and pagination but 500 rows chunks is very small when getting millions of rows)

Thanks for any help

2

@jbru

Send query by API - SQL | Dremio Documentation
Status of. query by API - Job | Dremio Documentation
For resulta - You can run from any ODBC/JDBC tool (truncation may happen if client tool has a limit, example Excel is 1 million)