← All Use Cases
MULTI-CLOUD CONSOLIDATION
End vendor lock-in
Sources scattered across BigQuery, Snowflake, and Redshift? DVT federates across all three into one unified target. Switch cloud providers without rewriting your pipeline. Your SQL models are engine-agnostic.
REAL-WORLD EXAMPLE
A SaaS company with acquisitions has data in BigQuery (marketing), Snowflake (finance), and Redshift (product). DVT consolidates all three into a single PostgreSQL analytics database.
DATA FLOW
WHAT ENABLES THIS
DIALECT TRANSPILATION →
one DuckDB-dialect model compiles to each warehouse's SQL automatically
SWITCHING THE DEFAULT TARGET →
proven: 67/67 models green after swapping the lakehouse with a 2-line profile change
SUPPORTED DATABASES →
all three warehouses are first-class federation sources on the Max plan
RELATED USE CASES
Sound like your situation? You can have the first model running today.