DATABASE ADAPTERS

DVT includes 19 database adapters in one package. Every adapter supports pushdown execution, extraction as a source, and materialization as a target.

All drivers are installed automatically by dvt sync.

POSTGRESQL

postgres

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

Port 5432

SNOWFLAKE

snowflake

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

Port 443

BIGQUERY

bigquery

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

REDSHIFT

redshift

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

Port 5439

DATABRICKS

databricks

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

Port 443

MYSQL

mysql

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

Port 3306

MARIADB

mariadb

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

Port 3306

SQL SERVER

sqlserver

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

Port 1433

ORACLE

oracle

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

Port 1521

DUCKDB

duckdb

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

SPARK

spark

Distributed compute engine for large-scale data processing. Used with Hive Metastore, HDFS, and cloud storage.

Port 10000

MICROSOFT FABRIC

fabric

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

Port 1433

CLICKHOUSE

clickhouse

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

Port 9000

TRINO

trino

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

Port 8080

SQLITE

sqlite

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

SINGLESTORE

singlestore

Distributed SQL database for real-time analytics and transactions. MySQL wire-protocol compatible with scale-out architecture.

Port 3306

AMAZON ATHENA

athena

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

VERTICA

vertica

Columnar analytics database designed for large-scale data warehousing. Known for high-performance complex queries on massive datasets.

Port 5433