DF_COMPUTE_URL

Pinned compute-node URL. Presence disables Auto routing. Default: http://localhost:3031.

Syntax

DF_COMPUTE_URL=<URL>

Description

## Overview `DF_COMPUTE_URL` pins the CLI to a single compute node for the lifetime of the process. Setting it bypasses the Auto routing path that would otherwise ask the control plane to pick a healthy node. Use it when you need reproducibility (benchmarks, debugging a specific worker) or when the control plane is unreachable but a known worker is. ## Behavior - Read by `std::env::var("DF_COMPUTE_URL")` at CLI startup via `CliConfig::from_env`. - Default when unset and no profile is loaded: `http://localhost:3031`. - Presence of the env var sets `compute_url_explicit = true` and `compute_url_auto = false`. The CLI then sends every statement to this URL directly instead of calling `/list-compute-nodes`. - Overridden at runtime by `--compute-url`. Overrides `compute_url` in the active profile. - URL must include scheme (`http://` or `https://`). ## Resolution - `--compute-url` flag (highest) - `DF_COMPUTE_URL` - `compute_url` in the active profile of `~/.deltaforge/config.toml` - Built-in default `http://localhost:3031` (lowest)

Examples

# Pin this shell to one worker
DF_COMPUTE_URL=http://worker-01.internal:3031 delta-forge-cli

# Export for a whole session
export DF_COMPUTE_URL=http://worker-az-east-1:3031

# Pull a pinned worker from a secret store
export DF_COMPUTE_URL=$(secret-tool lookup service deltaforge attribute compute-url)
delta-forge-cli run nightly_job.sql

# Benchmark a specific node while leaving the rest of the team on Auto
DF_COMPUTE_URL=http://bench-worker-02:3031 delta-forge-cli query SELECT count(*) FROM sales.orders

Pitfalls

• Setting `DF_COMPUTE_URL` silently disables Auto routing, even if you intended it as a fallback default. If the pinned node goes unhealthy the CLI will not fail over; it returns the connection error from that node.
• Captured at process start. Changing the value mid-session (or switching which worker is healthy) has no effect until you relaunch the CLI.
• The pin applies to every statement, including long-running jobs. Pair with `DF_HTTP_TIMEOUT_SECS` if the pinned worker runs operations that exceed the default 30 minute timeout.

See Also

• CLI_FLAG_COMPUTE_URL
• CLI_COMPUTE_AUTO
• CLI_COMPUTE_EXPLICIT