CLI REFERENCE

dvt run

Extract sources, transform models, load to targets.

dvt run                          # Run all models (incremental)
dvt run --full-refresh           # Rebuild everything from scratch
dvt run --select model_name      # Run specific model
dvt run --select tag:finance     # Run models with tag
dvt run --target prod            # Run against production target

dvt build

Seeds + models + snapshots + tests in DAG order.

dvt build                        # Full build
dvt build --full-refresh         # Clean rebuild
dvt build --select +model_name+  # Model with upstream/downstream

dvt seed

Load CSV files via Sling (10-100x faster than dbt).

dvt seed                         # Load all seeds
dvt seed --select seed_name      # Load specific seed
dvt seed --full-refresh          # Truncate and reload

dvt test

Run data tests on target.

dvt test                         # All tests
dvt test --select model_name     # Tests for specific model

dvt show

Run queries locally in DuckDB without hitting the warehouse.

dvt show --select model_name     # Preview model output
dvt show --inline "SELECT 1"     # Ad-hoc query
dvt show --limit 100             # Limit rows

dvt sync

Self-healing environment bootstrap. Installs drivers, DuckDB extensions, Sling.

dvt sync                         # Bootstrap everything

dvt debug

Test all database connections (adapter + Sling).

dvt debug                        # Test all connections
dvt debug --target snowflake_dev # Test specific target

dvt init

Initialize a new DVT project.

dvt init                         # Interactive project setup
dvt init my_project              # Create named project

dvt retract

Drop models from targets in reverse DAG order.

dvt retract                      # Retract all models
dvt retract --select model_name  # Retract specific model

dvt docs

Generate and serve the data catalog with cross-engine metadata.

dvt docs generate                # Generate catalog
dvt docs serve                   # Serve UI on localhost
dvt docs serve --port 9090       # Custom port

dvt clean

Remove build artifacts (target/, .dvt/, dvt_packages/).

dvt clean                        # Clean everything

PASSTHROUGH COMMANDS

These work identically to dbt:

  • dvt compileCompile models without executing
  • dvt parseParse project and build manifest
  • dvt list / dvt lsList resources
  • dvt snapshotRun snapshot models
  • dvt depsInstall dbt packages
  • dvt source freshnessCheck source freshness
  • dvt run-operationRun a macro