dbt connects to and runs SQL against your database, warehouse, lake, or query engine. These SQL-speaking platforms are collectively referred to as data platforms. dbt connects with data platforms by using a dedicated adapter plugin for each. Plugins are built as Python modules that dbt Core discovers if they are installed on your system. Refer to the Build, test, document, and promote adapters guide. for more info.
You can connect to adapters and data platforms natively in dbt Cloud or install them manually using dbt Core.
You can also further customize how dbt works with your specific data platform via configuration: see Configuring Postgres for an example.
dbt Cloud support for the Azure Synapse Analytics adapter is coming soon!
Types of Adapters
There are three types of adapters available today:
- Verified — Verified adapters are those that have completed a rigorous verification process in collaboration with dbt Labs.
- Trusted — Trusted adapters are those where the adapter maintainers have agreed to meet a higher standard of quality.
- Community — Community adapters are open-source and maintained by community members.
The following are Verified adapters ✓ you can connect to either in dbt Cloud or dbt Core:
The following are Trusted adapters ✓ you can connect to in dbt Core: