Skip to main content

Supported Data Platforms

dbt connects to and runs SQL against your database, warehouse, lake or query engine. To keep things simple, we group all of these SQL-speaking things into one bucket called "data platforms". dbt can be extended to any data platform by means of a dedicated adapter plugin. These plugins are built as separate Python modules that dbt Core will discover them if they are installed on your system. All the adapters listed below are open source and free to use, just like dbt Core.

To learn more about adapters, check out "What Are Adapters".

Adapter Installation​

With a few exceptions 1, all adapters listed below can be installed from PyPI using pip install <ADAPTER-NAME>. The installation will include dbt-core and any other required dependencies, which may include both other dependencies and even other adapter plugins. Read more about installing dbt.

Adapter Taxonomy​

Verified by dbt Labs​

In order to provide a more consistent and reliable experience, dbt Labs now has a rigorous process by which we verify adapter plugins. The process covers aspects of development, documentation, user experience and maintenance. These adapters earn a "Verified" designation so that users can have a certain level of trust and expectation when they use them. To learn more see "Verifying a new adapter

We also welcome and encourage adapter plugins from the dbt community (see the below "Contributing to a pre-existing adapter"). Please note that these community maintainers are intrepid volunteers who owe you nothing, but give anyway -- so be kind and understanding, and help out where you can!

Maintainers​

Who made and maintains and adapter is certainly relevant, but we recommend using an adapter's verification status to determine quality and health of an adapter. So far we have three categories of maintainers:

Supported byMaintained By
dbt Labsdbt Labs maintains a set of adapter plugins for some of the most common databases, warehouses, and platforms. As for why particular data platforms were chosen, see "Why Verify an Adapter"
PartnerThese adapter plugins are built and maintained by the same people who build and maintain the complementary data technology
CommunityThese adapter plugins are contributed and maintained by members of the community 🌱

Supported Data Platforms​

Verified Adapters​

Data PlatformAdapter Repositorylatest verified versionEnabled in dbt CloudProfile SetupConfigurationdbt Community Slack channelMaintained By
AlloyDBdbt-postgres(same as dbt-postgres)βœ…AlloyDB Profile#db-postgresn/a
BigQuerydbt-bigquery1.2.0βœ…BigQuery ProfileBigQuery Configs#db-bigquerydbt Labs
Databricksdbt-databricks1.2.0 🚧Databricks ProfileDatabricks Configs#db-databricks-and-sparkDatabricks
Postgresdbt-postgres1.2.0βœ…Postgres Profile#db-postgresdbt Labs
Redshiftdbt-redshift1.2.0βœ…Redshift ProfileRedshift Configs#db-redshiftdbt Labs
Snowflakedbt-snowflake1.2.0βœ…Snowflake ProfileSnowflake Configs#db-snowflakedbt Labs
Apache Sparkdbt-spark1.2.0βœ…Spark ProfileSpark Configs#db-databricks-and-sparkdbt Labs
Starburst & Trinodbt-trino1.2.0 🚧Trino Profile#db-presto-trinoStarburst

Community Adapters​

Data PlatformAdapter RepositoryProfile SetupConfigurationSlack ChannelMaintained By
Athenadbt-athenaAthena Profile#db-athenaCommunity
ClickHousedbt-clickhouseClickhouse ProfileClickhouse Configs#db-clickhouseClickhouse
IBM DB2dbt-ibmdb2DB2 Profilen/aCommunity
DuckDBdbt-duckdbDuckDB Profile#db-duckdbCommunity
Dremiodbt-dremioDremio Profilen/aCommunity
Exasol Analyticsdbt-exasolExasol Profilen/aCommunity
Fireboltdbt-fireboltFirebolt ProfileFirebolt Configs#db-fireboltFirebolt
AWS Gluedbt-glueGlue ProfileGlue Configs#db-glueAWS
Greenplumdbt-greenplumGreenplum ProfileGreenplum Configsn/aCommunity
Hivedbt-hiveHive ProfileHive Configs#db-hiveCloudera
Impaladbt-impalaImpala ProfileImpala Configs#db-impalaCloudera
iometedbt-iometeiomete Profile#db-iometeIomete
Layerdbt-layerLayer Profile#tools-layerLayer AI
Materializedbt-materializeMaterialize ProfileMaterialize Configs#db-materializeMaterialize
MindsDBdbt-mindsdbMindsDB ProfileMindsDB Configsn/aMindsDB
MySQLdbt-mysqlMySQL Profile#db-mysql-familyCommunity
Oracledbt-oracleOracle Profile#db-oracleOracle
Rocksetdbt-rocksetRockset Profile#db-rocksetRockset
SingleStoredbt-singlestoreSingleStore Profile#db-singlestoreSingle Store
SQLitedbt-sqliteSQLite Profilen/aCommunity
SQL Server & Azure SQLdbt-sqlserverSQL Server ProfileSQL Server Configs#db-sqlserverCommunity
Azure Synapsedbt-synapseSynapse ProfileSynapse Configs#db-synapseCommunity
Teradatadbt-teradataTeradata ProfileTeradata Configs#db-teradataTeradata
TiDBdbt-tidbTiDB Profile#db-tidbPingCAP
Verticadbt-verticaVertica Profilen/aCommunity

Contributing to dbt-core adapters​

Contributing to a pre-existing adapter​

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 channel, #adapter-ecosystem, in dbt Slack and the channel for your adapter's data store (see "Slack Channel" column of above tables)
  • Check out the open issues in the plugin's source repository (follow relevant link in "Adapter Repository" column of above tables)

Creating a new adapter​

If you see something missing from the lists above, and you're interested in developing an integration, read more about adapters and how they're developed in the "Adapter Development" section.

If you have a new adapter, please add it to this list using a pull request! See Documenting your adapter for more information.


  1. Here are the two different adapters. Use the PyPI package name when installing with pip

    Adapter repo namePyPI package name
    dbt-athenadbt-athena-adapter
    dbt-layerdbt-layer-bigquery

    ↩