Get SQL Query Status
db_sql_exec_status(
statement_id,
host = db_host(),
token = db_token(),
perform_request = TRUE
)
String, query execution statement_id
Databricks workspace URL, defaults to calling db_host()
.
Databricks workspace token, defaults to calling db_token()
.
If TRUE
(default) the request is performed, if
FALSE
the httr2 request is returned without being performed.
This request can be used to poll for the statement's status.
When the status.state
field is SUCCEEDED
it will also return the result
manifest and the first chunk of the result data.
When the statement is in the terminal states CANCELED
, CLOSED
or
FAILED
, it returns HTTP 200
with the state set.
After at least 12 hours in terminal state, the statement is removed from the
warehouse and further calls will receive an HTTP 404
response.
Other SQL Execution APIs:
db_sql_exec_cancel()
,
db_sql_exec_query()
,
db_sql_exec_result()