API can submit a job defined by a SQL, meantime a SQL may requires quiet a long time to complete. For fully automation based on the APIs Dremio provides, I’m considering if Dremio can add a feature allowing an external API address can be configured in Dremio to accept a feedback request telling it the result status of a job, no matter of completion, failure or cancellation, which is also called webhook or something. Later on an application correspondingly sends a request to Dremio for further operations instead of polling status.
Dremio does not support webhooks or any similar notification system - you would have to poll the job status periodically (http://docs.dremio.com/rest-api/jobs/get-job.html).