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|
|Redshift||Profile Setup, Configuration||✅||✅|
|BigQuery||Profile Setup, Configuration||✅||✅|
|Snowflake||Profile Setup, Configuration||✅||✅|
|Apache Spark||Profile Setup, Configuration||✅||✅|
|Databricks||Profile Setup, Configuration||✅||✅|
|Presto||Profile Setup||partial support|
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|
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|
|Azure Synapse||Profile Setup||Azure Synapse 10+|
|Exasol Analytics||Profile Setup||Exasol 6.x and later|
|Oracle Database||Profile Setup||Oracle 11+|
|Dremio||Profile Setup||Dremio 4.7+|
|ClickHouse||Profile Setup||ClickHouse 20.11+|
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.