Databricks Workflows is the extremely obtainable, fully-managed orchestrator for all of your information, analytics, and AI workloads. In the present day, we’re completely satisfied to announce the general public preview of the brand new SQL process sort, which helps you to simply creator, schedule, examine, and function workflows that refresh Databricks SQL queries, dashboards and alerts. You may mix this new process sort with present sturdy assist for notebooks, Python scripts and dbt initiatives to orchestrate the complete energy of the lakehouse.
Actual-world workflows orchestrate many alternative actions throughout the lakehouse. Take into account a workflow that ingests information into Delta Lake and transforms it utilizing a Delta Dwell Desk. As soon as this information is up to date, now you can instruct Databricks to refresh a number of dashboards or execute SQL queries. It’s also possible to run alerts to examine numerous information high quality dimensions and ship notifications to Slack or Groups if specified circumstances are met. Orchestrating these SQL duties contained in the workflow the place information is ready has a number of advantages: not solely is the workflow simpler to motive about, it’s also straightforward to restore and decide up the place it failed.
With the intention to create a Databricks SQL process, merely go to Databricks Workflows and choose “SQL” from the Kind dropdown:
You additionally profit from the observability and stability advantages that include our jobs scheduler comparable to managing schedules and inspecting earlier runs.