Overview Quickstart dbt Compatibility The Style Guide profiles.yml sources.yml Configuration Supported Databases

DATABASE ADAPTERS

DVT supports every engine that both dbt and Sling support — dbt provides the execution layer for your default target, Sling moves the data during federation. Every adapter below works as a federation source, a federation target, and a seed target.

All drivers are installed automatically by dvt sync based on what your profiles.yml actually uses.

Click any adapter for its setup guide, supported features, and federation notes.

TRANSACTIONAL ENGINES & LOCAL FILES

POSTGRESQL

Open-source relational database. The most popular choice for on-premises analytics and operational data stores.

MYSQL

The world's most popular open-source database. Widely used for operational/transactional workloads and web applications.

MARIADB

Community-developed fork of MySQL. Drop-in replacement with enhanced performance and additional storage engines.

SQL SERVER

Microsoft's enterprise relational database. Dominant in corporate environments, especially with .NET ecosystems.

ORACLE

Enterprise-grade relational database. Industry standard for mission-critical financial, ERP, and healthcare systems.

DUCKDB

In-process analytical database. DVT uses DuckDB internally for federation compute and as the extraction cache engine.

SQLITE

Serverless, file-based relational database. Ideal for local development, testing, and embedded analytics.

LOCAL FILESYSTEM

Local directories as sources and targets — Parquet, CSV, JSON and friends, no cloud account needed.

CLOUD BUCKETS

AMAZON S3

Materialize models and seeds as Parquet/CSV objects; read lake files as sources. MinIO-compatible.

GOOGLE CLOUD STORAGE

GCS buckets as federation sources and targets for your GCP-side lake.

AZURE BLOB STORAGE

Blob containers as sources and targets. Azurite-compatible for local development.

CLOUD WAREHOUSES

SNOWFLAKE

Cloud-native data warehouse with automatic scaling. Popular for analytics workloads and as a central data platform.

BIGQUERY

Google's serverless, highly scalable data warehouse. Pay-per-query pricing makes it cost-effective for intermittent analytics.

REDSHIFT

Amazon's cloud data warehouse based on PostgreSQL. Designed for petabyte-scale analytics with familiar SQL syntax.

DATABRICKS

Unified analytics platform combining data engineering, data science, and business analytics on a lakehouse architecture.

MICROSOFT FABRIC

Microsoft's unified analytics platform combining data engineering, data science, and business intelligence in one SaaS offering.

CLICKHOUSE

Column-oriented OLAP database for real-time analytics. Designed for sub-second queries over billions of rows.

TRINO

Distributed SQL query engine for federated analytics across heterogeneous data sources. Formerly known as Presto.

AMAZON ATHENA

AWS serverless query service for analyzing data in S3 using standard SQL. Pay-per-query with no infrastructure to manage.

BEYOND ENGINES: PYTHON MODEL SOURCES

Python models run locally and can pull from anything Python reaches — the result lands in your DAG like any other model and materializes to any target above. Like everything in DVT, they're free for individuals. That makes systems without a dbt+Sling adapter first-class sources anyway. Python models docs →

REST APIS

Stripe, HubSpot, internal services — anything with an HTTP endpoint

MONGODB

documents → DataFrames

ELASTICSEARCH

search indexes and aggregations

STARROCKS

MySQL-wire protocol

EXCEL / LOCAL FILES

spreadsheets, exports, anything pandas reads

ML INFERENCE

score, classify, embed — inline in the DAG

Not supported:engines without a Sling connector — Vertica, SingleStore, and self-hosted Spark Thrift — are outside the dbt + Sling intersection and have no native adapter. MongoDB, Elasticsearch, and StarRocks are best reached through Python models (above). Adapters marked SUPPORTED follow the same dbt + Sling rule but haven't been run in our live verification suite yet; VERIFIED adapters are exercised end-to-end (federation source + target, seeds, debug) on every release.