Use this action to trigger an existing Databricks job from your automation workflow.

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 unique identifier of the Databricks job that you want to execute.

    You can insert a value using the Insert a value icon.

  • Specify the job parameters to pass runtime parameters to the Databricks job.
  • Select from the following parameter options.
    • On the Dictionary tab, click Add to add dictionary parameters.
      Parameter Description
      Type Specify the data type of the parameter value. Supported data types are:
      • Any
      • String
      • Number
      • Datetime
      • Boolean
      Key Enter the name of the parameter as referenced in the SQL statement.
      Value (Optional) Enter a value or click Insert a value to select a variable.
    • On the Variable tag, enter the variable or click Insert a value to select a variable.
  • In the Assign output to a variable field, select one of the following options to store the result of run job action.
    • 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 such as job Id, run Id, status, and message. If the variable is not available in the list, click Create variable.
When the Run job action is executed, the following output keys are returned and can be captured using either Multiple variables or a Dictionary:
Key Description
job_id Unique identifier of the Databricks job that was triggered.
run_id Unique identifier for the specific execution (run instance) of the job.
status Current execution status of the job (For example, Pending, Running, Success, Failed).
message Additional details or response message returned by the Databricks API.