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 for | Documentation | Core features | dbt Cloud | Install from PyPi |
---|---|---|---|---|
Postgres | Profile Setup | β | β | pip install dbt-postgres |
Redshift | Profile Setup, Configuration | β | β | pip install dbt-redshift |
BigQuery | Profile Setup, Configuration | β | β | pip install dbt-bigquery |
Snowflake | Profile Setup, Configuration | β | β | pip install dbt-snowflake |
Apache Spark | Profile 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 for | Documentation | Install from PyPi |
---|---|---|
ClickHouse (dbt-clickhouse) | Profile Setup, Configuration | pip install dbt-clickhouse |
Databricks (dbt-databricks) | Profile Setup, Configuration | pip install dbt-databricks |
Firebolt (dbt-firebolt) | Profile Setup, Configuration | pip install dbt-firebolt |
Impala (dbt-impala) | Profile Setup, Configuration | pip install dbt-impala |
iomete (dbt-iomete) | Profile Setup | pip install dbt-iomete |
Layer Bigquery (dbt-layer) | Profile Setup | pip install dbt-layer-bigquery |
Materialize (dbt-materialize) | Profile Setup, Configuration | pip install dbt-materialize |
MindsDB (dbt-mindsdb) | Profile Setup, Configuration | pip install dbt-mindsdb |
Oracle (dbt-oracle) | Profile Setup | pip install dbt-oracle |
Rockset (dbt-rockset) | Profile Setup | pip install dbt-rockset |
SingleStore (dbt-singlestore) | Profile Setup | pip install dbt-singlestore |
Starburst & Trino (dbt-trino) | Profile Setup | pip install dbt-trino |
Teradata (dbt-teradata) | Profile Setup, Configuration | pip install dbt-teradata |
TiDB (dbt-tidb) | Profile Setup | pip install dbt-tidb |
Community Supportedβ
These adapter plugins are contributed and maintained by members of the community π±
Adapter for | Documentation | Notes | Install with pip |
---|---|---|---|
SQL Server & Azure SQL | Profile Setup, Configuration | SQL Server 2016 and later | pip install dbt-sqlserver |
Azure Synapse | Profile Setup, Configuration | Azure Synapse 10+ | pip install dbt-synapse |
Exasol Analytics | Profile Setup | Exasol 6.x and later | pip install dbt-exasol |
Dremio | Profile Setup | Dremio 4.7+ | pip install dbt-dremio |
Athena | Profile Setup | Athena engine version 2 | pip install git+https://github.com/Tomme/dbt-athena.git |
Vertica | Profile Setup | Vertica 10.0+ | pip install dbt-vertica |
AWS Glue | Profile Setup, Configuration | Glue 2.0+ | pip install dbt-glue |
Greenplum | Profile Setup, Configuration | Greenplum 6.0+ | pip install dbt-greenplum |
DuckDB | Profile Setup | DuckDB 0.3.2 | pip install dbt-duckdb |
SQLite | Profile Setup | SQlite Version 3.0+ | pip install dbt-sqlite |
MySQL | Profile Setup | MySQL 5.7 and 8.0 | pip install dbt-mysql |
IBM DB2 | Profile Setup | IBM 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.