ANALYTICS ENGINEERING
dbt + any source
Already using dbt? DVT extends your project to reference sources beyond your warehouse. Add Oracle ERP data, SQL Server operational data, or S3 files — without changing your existing models. Same ref(), same source(), same everything.
REAL-WORLD EXAMPLE
A data team using dbt with Snowflake needs to join CRM data from an on-prem Oracle instance. Instead of building a separate Fivetran pipeline, they add the Oracle source to their DVT project and write one SQL model.
DATA FLOW
WHAT ENABLES THIS
DROP INTO AN EXISTING PROJECT →
DVT wraps stock dbt-core — your models, macros, and packages run unchanged
SOURCES.YML & META.CONNECTION →
four yaml lines bind a source to another engine; ref() and source() stay the same
.SQL MODELS →
f_table and f_incremental sit beside your existing materializations
RELATED USE CASES
Sound like your situation? You can have the first model running today.