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.

Fishtown Supported

In addition to maintaining dbt-core, Fishtown Analytics 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
Microsoft SQL ServerProfile SetupSQL Server 2008 R2 and laterpip install dbt-mssql
Microsoft SQL ServerProfile SetupSQL Server 2016 and laterpip install dbt-sqlserver
Microsoft Azure Synapse DWProfile SetupAzure Synapse 10+pip install dbt-synapse
Microsoft Azure Synapse DWProfile SetupAzure Synapse 10+pip install dbt-azuresynapse
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

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 2021.

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.