Get SQL Query Results
db_sql_exec_result(
statement_id,
chunk_index,
host = db_host(),
token = db_token(),
perform_request = TRUE
)
String, query execution statement_id
Integer, chunk index to fetch result. Starts from 0
.
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.
After the statement execution has SUCCEEDED
, this request can be used to
fetch any chunk by index.
Whereas the first chunk with chunk_index = 0
is typically fetched with
db_sql_exec_result()
or db_sql_exec_status()
, this request can be used
to fetch subsequent chunks
The response structure is identical to the nested result element described
in the db_sql_exec_result()
request, and similarly includes the
next_chunk_index
and next_chunk_internal_link
fields for simple
iteration through the result set.
Other SQL Execution APIs:
db_sql_exec_cancel()
,
db_sql_exec_query()
,
db_sql_exec_status()