Cancels an active Databricks SQL statement using a specified session and SQL statement ID. The action uses the selected session (directly or via a variable) to connect to Databricks, identifies the target SQL statement, and stops its execution.

Settings

  • Use the Session field to select one of the following options:
    • Session name: Enter the name of the session used during Connect action.

      Click the Insert a value icon to select an existing variable that you have used to store the default session name.

    • Variable: Enter the name of the variable that you have used to store the session name.
  • Specify the SQL statement ID of the Databricks SQL statement that you want to cancel.

    Click the Insert a value icon to select an existing variable.

  • Select a variable that you want to use to store the output from the Assign the output to variable list.

    The output typically returns the final SQL statement status after the cancellation request is processed (For example, CANCELED, SUCCEEDED, FAILED), CLOSED.