dbt supports the following databases:
These database plugins are supported by the core dbt maintainers.
|Postgres||Profile Setup||✅Full Support|
|Redshift||Profile Setup, Configuration||✅Full Support|
|BigQuery||Profile Setup, Configuration||✅Full Support|
|Snowflake||Profile Setup, Configuration||✅ Full Support|
|Presto||Profile Setup||Partial Support|
|Spark||Profile Setup, Configuration||Partial Support|
Community Supported dbt Plugins
These database plugins are community-supported 🌱
|Microsoft SQL Server (dbt-mssql)||Profile Setup||SQL Server 2008 R2 and later|
|Microsoft SQL Server (dbt-sqlserver)||Profile Setup||SQL Server 2016 and later|
Creating a new adapter
dbt can be extended with "adapter plugins." These plugins can be built into separate Python modules, and dbt will discover them if they are installed on your system. If you're interested in developing a new adapter plugin for dbt, please open an issue and be sure to check out the docs on building a new adapter.