topic Re: How to build master workflow for all the jobs present in workflow using databricks? in Data Engineering

How to build master workflow for all the jobs present in workflow using databricks?

Ria — Mon, 06 Feb 2023 10:08:58 GMT

Suppose there are multiple job have been created using databricks workflow, now the requirement is to make one master workflow to trigger all the workflow depending on different condition like: some are supposed to trigger on daily basis, some on monthly basis, and some on weekly basis. Other condition to be checked is, before executing a job we need to check its dependency over other job, if So then we have to execute that workflow first then trigger next.

Re: How to build master workflow for all the jobs present in workflow using databricks?

Ajay-Pandey — Mon, 06 Feb 2023 11:12:14 GMT

Hi @Riya Vadhwani ,

Till now you cannot call databricks workflow job from another job, you can use databricks workflow job API to run your other job.

Please refer to this link for more information regarding JOB API

Re: How to build master workflow for all the jobs present in workflow using databricks?

Anonymous — Sat, 08 Apr 2023 07:34:28 GMT

Hi @Riya Vadhwani

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!

Re: How to build master workflow for all the jobs present in workflow using databricks?

erigaud — Fri, 14 Jul 2023 09:40:58 GMT

A nice way to do this is to use the databricks python sdk :

(%pip install databricks-sdk) from databricks.sdk import WorkspaceClient if condition: DATABRICKS_HOST = "your-hostname" DATABRICKS_TOKEN = "your-personnal-access-token" w = WorkspaceClient(host=DATABRICKS_HOST, token=DATABRICKS_TOKEN) w.jobs.run_now(your-job-id)

Re: How to build master workflow for all the jobs present in workflow using databricks?

pvignesh92 — Fri, 14 Jul 2023 13:42:28 GMT

@Ria Hi , This feature was in development when I attended last Quarter Roadmap and I thought it is available in the latest versions or could be even in Private Preview. You can check with your Databricks Solution Architect. Even if not now, could be coming up pretty soon.