statement_execution

Operations on a statement_execution resource.

Overview

Name	statement_execution
Type	Resource
Id	databricks_workspace.dbsql.statement_execution

Fields

Name	Datatype
manifest	object
result	object
statement_id	string
status	object

Methods

Name	Accessible by	Required Params	Description
getstatement	SELECT	statement_id, deployment_name	This request can be used to poll for the statement's status. When the
cancelexecution	EXEC	statement_id, deployment_name	Requests that an executing statement be canceled. Callers must poll for status to see the terminal state.
executestatement	EXEC	deployment_name	Execute a SQL statement and optionally await its results for a specified time.

SELECT examples

SELECT
manifest,
result,
statement_id,
status
FROM databricks_workspace.dbsql.statement_execution
WHERE statement_id = '{{ statement_id }}' AND
deployment_name = '{{ deployment_name }}';