Skip to content

rbutinar/ade-ops / .agents/skills/databricks-run

databricks-run

Verified

Execute Databricks Notebooks / Jobs

/databricks-run — Execute Databricks Notebooks / Jobs

You are executing a notebook run on a Databricks cluster.

Command (start here)

The framework ships this as a runnable command — works with no MCP server (plain REST from credentials.yaml). The notebook must already be in the workspace (deploy via /ops-push or /databricks-deploy first):

python -m core.cli databricks-run /Shared/proj/bronze/load --cluster {cluster_id}
python -m core.cli databricks-run bronze/load --env dev --param date=2026-01-01

A relative notebook path is prefixed with the env's workspace_path; the cluster resolves from --cluster > overlay databricks.cluster_id. It submits a one-time job run, blocks to terminal state, and logs the outcome to ops.log.

When the databricks MCP server is loaded, prefer it — cluster status/start (get_cluster_status, start_cluster) and tracked multi-task jobs. The MCP path is documented below; the CLI is the dependable fallback and the recommended default when no MCP is configured. (For multi-notebook pipelines/layers, today the CLI runs one notebook per invocation — loop with fail-fast, or use the MCP path.)

Prerequisites

  • Databricks MCP server databricks configured in .mcp.json (see ONBOARDING.md step 7)
  • Cluster RUNNING or startable
  • Notebooks already deployed to the workspace (via /ops-push or /databricks-deploy)

Usage

/databricks-run --env {env} --notebook {workspace_path}        # single notebook
/databricks-run --env {env} --layer bronze                     # all notebooks under {workspace_path}/bronze
/databricks-run --env {env} --pipeline                         # all notebooks in order (project-defined sequence)

Arguments via $ARGUMENTS:

  • --env {env} — required: resolves workspace_path, cluster_id from project.yaml + overlay
  • --notebook {path} — workspace path (absolute or relative to env workspace_path)
  • --layer {bronze|silver|gold|...} — subfolder under workspace_path
  • --pipeline — run all notebooks under workspace_path in order
  • --cluster {cluster_id} — override cluster (default from overlay or interactive prompt)
  • --timeout {seconds} — per-notebook timeout, default 3600

Behavior

Step 1: Resolve Project & Env

Find the active project (nearest ancestor of cwd with config/project.yaml). Read:

environments.{env}.platforms.databricks.workspace_path

Apply env-var expansion (e.g. ${DATABRICKS_USER_PATH}).

Step 2: Resolve Cluster

Look for cluster_id in this order:

  1. --cluster flag
  2. Overlay key databricks.cluster_id in overlays/{env}.yaml
  3. MCP mcp__databricks__list_clusters() — prompt user to pick

Cache the resolved cluster_id for the session.

Step 3: Pre-flight cluster state

mcp__databricks__get_cluster_status(cluster_id="{cluster_id}")

If state is TERMINATED:

  • Ask user: "Cluster {name} is terminated. Start it? (yes/no)"
  • On yes: mcp__databricks__start_cluster(cluster_id=...) then poll get_cluster_status every 30s until RUNNING
  • On no: abort

Step 4: Execute

Single notebook — use the Jobs API for proper tracking:

# Create one-time job
job = mcp__databricks__manage_jobs(
  action="create",
  name=f"ade-ops run: {notebook_name}",
  tasks=[{
    "task_key": notebook_name,
    "existing_cluster_id": cluster_id,
    "notebook_task": {"notebook_path": full_workspace_path}
  }]
)

# Trigger
run = mcp__databricks__manage_job_runs(action="run_now", job_id=job.job_id)

# Wait
result = mcp__databricks__manage_job_runs(
  action="wait",
  run_id=run.run_id,
  timeout={timeout},
  poll_interval=10
)

Pipeline / layer — sequential execution with fail-fast:

For each notebook in order:

  1. Submit and wait
  2. On failure → stop, report which notebook failed and the error
  3. On success → next

Step 5: Report & Log

Output a summary table:

=== Databricks Run ===
Env:       {env}
Cluster:   {cluster_name} ({cluster_id})
Notebooks: {n}

[1/N] {notebook} ... SUCCESS ({duration}s)
[2/N] {notebook} ... FAILED — {error}

=== SUMMARY ===
Succeeded: X
Failed:    Y
Skipped:   Z
Duration:  {seconds}

Append to project ops.log:

{ISO_timestamp} | {role} | RUN | {env} | {scope}: {n} notebooks ({succeeded} ok, {failed} fail) | {ok|fail}

REST fallback (no MCP)

If the databricks MCP server is not configured, use the command above (python -m core.cli databricks-run …) — it wraps exactly this REST path. The lower-level connector call it builds on (Jobs 2.1 runs/submit, submit + poll-to-terminal) is shown here for when you need to drive it from your own script:

from core.engine.config import load_credentials
from core.connectors.databricks import DatabricksConnector

conn = DatabricksConnector.from_credentials(
    load_credentials(project_root), host=db_host  # from project.yaml platforms.databricks.host
)
run = conn.run_notebook(
    full_workspace_path,
    existing_cluster_id=cluster_id,   # or new_cluster={...} for a job cluster
    base_parameters={...},            # optional
)
# raises RuntimeError on a non-success terminal state, TimeoutError on timeout

For a pipeline/layer, call run_notebook per notebook in order with the same fail-fast logic as Step 4.

Error Handling

ErrorAction
MCP databricks not availableUse the REST fallback (see above) — no MCP needed
Cluster TERMINATEDOffer to start
PERMISSION_DENIEDCluster owned by another user — pick a different one
Notebook not foundNotebook not deployed — suggest /ops-push or /databricks-deploy first
ModuleNotFoundError in notebookLibrary missing — install via %pip install in notebook

Notes

  • For SQL-only workloads, prefer /databricks-query (uses SQL warehouse, no cluster needed)
  • The Jobs API path produces tracked runs visible in the Databricks UI Jobs section — easier to debug than execute_databricks_command
  • Pipeline order: today it's "alphabetical within layer" — define an explicit order in overlays/{env}.yaml under databricks.pipeline_order (list of relative paths) to control execution sequence
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall