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 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]
DatabricksProfile Setup, Configurationโœ…โœ…pip install dbt-spark[ODBC]
PrestoProfile Setuppartial supportpip 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 forDocumentationInstall from PyPi
Materialize (dbt-materialize)Profile Setuppip install dbt-materialize

Community Supported

These adapter plugins are contributed and maintained by members of the community ๐ŸŒฑ

Adapter forDocumentationNotesInstall from PyPI
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
Oracle DatabaseProfile SetupOracle 11+pip install dbt-oracle
DremioProfile SetupDremio 4.7+pip install dbt-dremio
ClickHouseProfile SetupClickHouse 20.11+pip install dbt-clickhouse
TrinoProfile SetupTrino 359+pip install dbt-trino

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.