Troubleshooting, Monitoring, and Optimization · Topic 1 of 2

Monitoring Lakeflow Jobs Runs

Databricks DEA job monitoring: run history matrix and duration baselines, run and task statuses, the task graph to find upstream blockers, and repair runs.

  • 5 min
In a nutshell
  • The Runs tab has a matrix view for trends and a list view for run details.
  • Matrix bar height shows relative duration; task colors show status.
  • Succeeded with failures means some tasks failed but all leaf tasks succeeded.

What it is

Lakeflow Jobs keeps a record of every run: when it started, how long it took, which tasks succeeded and which failed. The UI turns that record into views that show trends over time and the state of one run.

Monitoring answers two questions. Is this run normal compared with earlier runs? And if it failed or ran long, which task caused it?

Runs tabmatrix viewSpot a slow or red runOpen the runtask graphOpen the taskoutput and errorRepair run

How it works

Run history for one job

Open the job from Jobs & Pipelines and select its Runs tab. It has two views.

ViewWhat it shows
Matrix viewOne column per run; a bar for the run total duration and a cell per task with its status
List viewOne row per run with start time, run ID, trigger, duration, status, error code and parameters

In the matrix view, bar height shows relative run duration, so a run that took twice as long as usual stands out at once. Hovering a bar or task cell shows its start time, duration and state.

Task cell colors make failures easy to spot.

ColorMeaning
GreenSuccessful
RedUnsuccessful
PinkSkipped
YellowWaiting for retry
GreyPending, canceled or timed out

Comparing against a baseline

The baseline is simply the job's recent normal runs. Compare the current bar with the bars before it, and compare each task cell's duration to find which task grew.

A slow trend across many runs usually means growing data volume or a layout problem. A single long run more often points to one bad input or a busy cluster.

You can set an expected completion time on the job. A warning appears when a run exceeds it, and a duration warning notification can alert the team before a timeout ends the run.

For longer history and reporting, the system.lakeflow system tables hold job and task run records across the account. Query them to chart run times and failure rates beyond what the UI shows.

Runs across all jobs

The Runs tab of Jobs & Pipelines lists runs of every job and pipeline you can access. With the list filtered to jobs or to pipelines, it shows a finished runs count graph for the last 48 hours, split into successful, failed and skipped runs.

It also lists the top 5 error types in the selected range. Filters such as run status and error code help track failure rates across the whole workspace.

Run statuses

StatusMeaning
SucceededAll tasks succeeded
Succeeded with failuresSome tasks failed, but all leaf tasks succeeded
FailedOne or more leaf tasks failed
SkippedThe run did not start, for example because maximum concurrent runs was reached
Timed OutThe run exceeded its timeout
CanceledSomeone or something canceled the run

A leaf task has no downstream tasks. That is why a failed task with a successful downstream task can still produce Succeeded with failures, for example when the downstream task runs on a condition other than All succeeded.

The task graph and upstream blockers

Opening a run shows its tasks as a graph that follows the job's dependencies. Each task carries its status, so the first red task in the chain is the blocker.

ingestfailedcleannot runaggregatenot rundashboard refreshnot run

With the default Run if setting of All succeeded, tasks below a failed task do not run and the run fails. Fix the first failure; the rest are only waiting on it.

Click the failed task to open its task run details, with the output and error message. For a Lakeflow Declarative Pipelines task, the pipeline's own page shows its dataset graph and event log with the failure.

Repairing a run

Repair run reruns only the unsuccessful tasks and the tasks that depend on them. Successful tasks are not rerun, which saves time and cost on long jobs.

Repair uses the current job settings, and you can override parameters in the repair dialog. Repair applies to jobs with two or more tasks; a single task job is simply run again.

How the exam asks about this

  • "Find whether today's run is slower than usual." Use the job's Runs tab matrix view and compare the run duration bars.
  • "A job failed and four downstream tasks did not run." Open the run's task graph and fix the first failed upstream task.
  • "Rerun only what failed after fixing a bug in one notebook." Use Repair run.

What to remember for the exam

  • The Runs tab has a matrix view for trends and a list view for run details.
  • Matrix bar height shows relative duration; task colors show status.
  • Succeeded with failures means some tasks failed but all leaf tasks succeeded.
  • With All succeeded, tasks below a failure do not run, so look for the first failed task.
  • Repair run reruns unsuccessful tasks and their dependents only.
  • The Jobs & Pipelines Runs tab and system.lakeflow tables track failure rates across jobs.
Watch out

The red task furthest downstream is rarely the cause. Downstream tasks fail or do not run because their upstream failed; always trace back to the first failure in the graph.

Common mistakes

Rerunning the whole job after one task fails. It repeats work that already succeeded. Repair run reruns only the unsuccessful tasks and their dependents.

Treating Skipped as a task bug. A skipped run usually means a limit such as maximum concurrent runs was reached, not that code failed.

Judging performance from one run. One slow run can be noise. Compare against the job's recent runs before tuning anything.

Check yourself

  • Which view shows whether recent runs of a job are getting slower?

    The matrix view on the job's Runs tab, where bar height shows each run's relative duration.

  • A run shows Succeeded with failures. What does that mean?

    At least one task failed, but every leaf task, a task with no downstream dependencies, succeeded.

  • What does Repair run rerun?

    Only the tasks that were unsuccessful and the tasks that depend on them; tasks that succeeded are not rerun.

Topic 1 of 2 in Troubleshooting, Monitoring, and Optimization

Test yourself on Troubleshooting, Monitoring, and Optimization

The full Databricks Data Engineer Associate question bank has 598 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Databricks. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.