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.

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
Databricks (dbt-databricks)Profile Setup, Configurationpip install dbt-databricks
Firebolt (dbt-firebolt)Profile Setup, Configurationpip install dbt-firebolt
Materialize (dbt-materialize)Profile Setup, Configurationpip install dbt-materialize
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 SetupSQL Server 2016 and laterpip install dbt-sqlserver
Azure SynapseProfile SetupAzure Synapse 10+pip install dbt-synapse
Exasol AnalyticsProfile SetupExasol 6.x and laterpip install dbt-exasol
DremioProfile SetupDremio 4.7+pip install dbt-dremio
ClickHouseProfile SetupClickHouse 20.11+pip install dbt-clickhouse
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

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.