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 details.
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 two types of adapters available today:
- Trusted — Trusted adapters are those where the adapter maintainers have decided to participate in the Trusted Adapter Program and have made a commitment to meeting those requirements. For adapters supported in dbt Cloud, maintainers have undergone an additional rigorous process that covers contractual requirements for development, documentation, user experience, and maintenance.
- Community — Community adapters are open-source and maintained by community members. These adapters are not part of the Trusted Adapter Program and could have usage inconsistencies.
Considerations for depending on an open-source project
- Does it work?
- Does anyone "own" the code, or is anyone liable for ensuring it works?
- Do bugs get fixed quickly?
- Does it stay up-to-date with new Core features?
- Is the usage substantial enough to self-sustain? pendency on this library?