I am using REST API of Dremio (SQL API) - Dremio to fetch dataset for my UI application (ReactJS).
Everything works fine except the fact that I have to keep calling(in loop) the Job API to know the status of the SQL JOB until it is completed, this is doesn’t seem efficient way as I am hitting the Dremio server continuously until I receive “COMPLETION” status.
Also my custom UI has a grid with pagination. so for every pagination, I have to execute the above.
Please suggest if there is any long polling or webhooks or any other solution to resolve the above.
or would you suggest to use to ODBC to create a custom web api?