This action enables you to retrieve the current status and lifecycle state of a specific Databricks job run using its run ID.

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.
  • Enter the unique run ID of the Databricks job whose status you want to check.
  • In the Assign output to a variable field, select one of the following options to store the result of the SQL execution.
    • Multiple variables: Stores the output in multiple variables by providing the key and the variable to which the key is mapped. This variable can be of any type, such as String, Number, Datetime.

      Click Add variable mapping to add key and map it to a variable. If the variable is not available in the list, click Create variable.

    • Dictionary: Select a dictionary variable to hold the output if the SQL statement returns a value. If the variable is not available in the list, click Create variable.

    Returns the current job run status, including lifecycle state (For example, pending, running, terminated), result state (For example, success, failed), and any relevant status metadata.