This action enables you to retrieve the output, logs, and result details 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 Databricks job run ID whose output you want to retrieve.
  • 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 job run output, including available result data, logs, error details, and run metadata from Databricks.