DATA VIRTUALIZATION TOOL

Your warehouse is every engine you already own.

DVT is a dbt-compatible transformation engine that reads from all your databases, computes across them, and lands everything on one target — no cloud warehouse required.

pip install dvt-coreQuickstart →Read the docs
15+ SQL engines4 object stores1 default target100% dbt-compatible0 data copied to start

ONE MODEL, MANY ENGINES

Write it once. DVT speaks every dialect for you.

A federation model is plain SQL. DVT decomposes it per engine, transpiles each extraction into that engine's own dialect — quoting included — pushes your filters down to the source, computes the join, and lands the result. Every extraction is guaranteed to parse on its target engine.

We even publish what doesn't push down →

-- one model, three engines

{{ config(materialized='f_table') }}

SELECT c.region, SUM(o.amount) revenue

FROM {{ source('postgres', 'customers') }} c

JOIN {{ source('oracle', 'orders') }} o ON c.id = o.customer_id

JOIN {{ source('snowflake', 'fx_rates') }} f ON o.currency = f.currency

WHERE o.amount > 100

GROUP BY c.region

-- lands on YOUR default target. filters pushed to all three.

MORE THAN A CLI

One command, a whole workbench.

dvt serve opens the local suite — every app on its own port, one login-free door, loopback-safe by default.

DATA CATALOG

:46101

Cross-engine docs and lineage — every model, source and column across all your connections, one graph.

API PORTAL

:46102

Any model becomes a live REST endpoint — executed through federation per request, Denodo-style, with column governance.

DVT SCHEDULER

:46106

Your dvt commands on a cron or saved for manual runs — with kill switches, history and honest per-run feedback.

DVT SETTINGS

:46100

Account, machine sizing, a no-YAML connection manager for profiles.yml, AI credentials, and the hosting map.

ON THE ROADMAP · builder · chat with data · profiling · notebooks · dashboards

NO MAGIC CLAIMS

We publish our limitations.

What degrades gracefully, where the hard walls are, and which guarantees are enforced by our test battery across ten dialects — on a public page, kept honest release by release. Engineers notice.

Read the limitations page →

BUILT FOR LOCKED-DOWN FLOORS

Air-gapped? First-class.

Offline machine-bound activation, credential writes that never leave loopback, a published port map for your network admins, and AI features that can run against local models. No phone-home required to do your job.

DVT for the enterprise →

Keep your engines. Gain a warehouse.

Free for files and databases. Pay when you connect clouds.