Skip to main content

Available adapters

dbt connects to and runs SQL against your database, warehouse, platform, or query engine. It works by using a dedicated adapter for each technology. All the adapters listed below are open source and free to use, just like dbt.

If you have a new adapter, please add it to this list using a pull request! See Documenting your adapter for more information.

Installation​

Most adapters can be installed from PyPi using pip. The installation will include dbt-core and any other required dependencies, which may include other adapter plugins. Read more about installing dbt.

Some vendor or community adapters may not exist in PyPi. However, you can still install an adapter hosted on GitHub with pip install, by replacing MAINTAINER_NAME with the person or company maintaining the adapter on GitHub and ADAPTER_NAME with the git repository's name (these can be taken directly from the adapter's url):

pip install git+https://github.com/MAINTAINER_NAME/ADAPTER_NAME.git

dbt Labs Supported​

In addition to maintaining dbt-core, dbt Labs maintains a set of adapters for some of the most common databases, warehouses, and platforms. (βœ… indicates "full support.")

Adapter forDocumentationCore featuresdbt CloudInstall from PyPi
PostgresProfile Setupβœ…βœ…pip install dbt-postgres
RedshiftProfile Setup, Configurationβœ…βœ…pip install dbt-redshift
BigQueryProfile Setup, Configurationβœ…βœ…pip install dbt-bigquery
SnowflakeProfile Setup, Configurationβœ…βœ…pip install dbt-snowflake
Apache SparkProfile Setup, Configurationβœ…βœ…pip install dbt-spark[PyHive]

Vendor Supported​

These adapter plugins are built and maintained by the same people who build and maintain the complementary data technology.

Adapter forDocumentationInstall from PyPi
ClickHouse (dbt-clickhouse)Profile Setup, Configurationpip install dbt-clickhouse
Databricks (dbt-databricks)Profile Setup, Configurationpip install dbt-databricks
Firebolt (dbt-firebolt)Profile Setup, Configurationpip install dbt-firebolt
Impala (dbt-impala)Profile Setup, Configurationpip install dbt-impala
iomete (dbt-iomete)Profile Setuppip install dbt-iomete
Layer Bigquery (dbt-layer)Profile Setuppip install dbt-layer-bigquery
Materialize (dbt-materialize)Profile Setup, Configurationpip install dbt-materialize
MindsDB (dbt-mindsdb)Profile Setup, Configurationpip install dbt-mindsdb
Oracle (dbt-oracle)Profile Setuppip install dbt-oracle
Rockset (dbt-rockset)Profile Setuppip install dbt-rockset
SingleStore (dbt-singlestore)Profile Setuppip install dbt-singlestore
Starburst & Trino (dbt-trino)Profile Setuppip install dbt-trino
Teradata (dbt-teradata)Profile Setup, Configurationpip install dbt-teradata
TiDB (dbt-tidb)Profile Setuppip install dbt-tidb

Community Supported​

These adapter plugins are contributed and maintained by members of the community 🌱

Adapter forDocumentationNotesInstall with pip
SQL Server & Azure SQLProfile Setup, ConfigurationSQL Server 2016 and laterpip install dbt-sqlserver
Azure SynapseProfile Setup, ConfigurationAzure Synapse 10+pip install dbt-synapse
Exasol AnalyticsProfile SetupExasol 6.x and laterpip install dbt-exasol
DremioProfile SetupDremio 4.7+pip install dbt-dremio
AthenaProfile SetupAthena engine version 2pip install git+https://github.com/Tomme/dbt-athena.git
VerticaProfile SetupVertica 10.0+pip install dbt-vertica
AWS GlueProfile Setup, ConfigurationGlue 2.0+pip install dbt-glue
GreenplumProfile Setup, ConfigurationGreenplum 6.0+pip install dbt-greenplum
DuckDBProfile SetupDuckDB 0.3.2pip install dbt-duckdb
SQLiteProfile SetupSQlite Version 3.0+pip install dbt-sqlite
MySQLProfile SetupMySQL 5.7 and 8.0pip install dbt-mysql
IBM DB2Profile SetupIBM DB2 V9fp2+pip install dbt-ibmdb2

Community-supported plugins are works in progress, and anyone is welcome to contribute by testing and writing code. If you're interested in contributing:

  • Join both the dedicated #adapter-ecosystem channel in dbt Slack and the channel for your adapter's data store (e.g. #db-sqlserver, #db-athena)
  • Check out the open issues in the plugin's source repository

Note that, while no community plugins are currently supported in dbt Cloud, we expect this to change in the near future.

Creating a new adapter​

dbt can be extended to any SQL-speaking database, warehouse, data lake, query engine, or analytical platform by means of an adapter plugin. These plugins can be built as separate Python modules, and dbt will discover them if they are installed on your system. If you see something missing from the lists above, and you're interested in developing an integration, read more about building a new adapter.