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.
Any adapter 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.
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] |
| Databricks | Profile Setup, Configuration | ✅ | ✅ | pip install dbt-spark[ODBC] |
| Presto | Profile Setup | partial support | pip install dbt-presto |
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 |
|---|---|---|
| Materialize (dbt-materialize) | Profile Setup | pip install dbt-materialize |
| Rockset (dbt-rockset) | Profile Setup | pip install dbt-rockset |
| Starburst & Trino (dbt-trino) | Profile Setup | pip install dbt-trino |
| Firebolt (dbt-firebolt) | Profile Setup, Configuration | pip install dbt-firebolt |
| Teradata (dbt-teradata) | Profile Setup, Configuration | pip install dbt-teradata |
Community Supported
These adapter plugins are contributed and maintained by members of the community 🌱
| Adapter for | Documentation | Notes | Install from PyPI |
|---|---|---|---|
| SQL Server & Azure SQL | Profile Setup | SQL Server 2016 and later | pip install dbt-sqlserver |
| Azure Synapse | Profile Setup | Azure Synapse 10+ | pip install dbt-synapse |
| Exasol Analytics | Profile Setup | Exasol 6.x and later | pip install dbt-exasol |
| Oracle Database | Profile Setup | Oracle 11+ | pip install dbt-oracle |
| Dremio | Profile Setup | Dremio 4.7+ | pip install dbt-dremio |
| ClickHouse | Profile Setup | ClickHouse 20.11+ | pip install dbt-clickhouse |
Community-supported plugins are works in progress, and all users are encouraged to contribute by testing and writing code. If you're interested in contributing:
- Join the dedicated channel in dbt Slack (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.