Development Status
- 5 - Production/Stable
License
- OSI Approved :: Apache Software License
Operating System
- MacOS :: MacOS X
- Microsoft :: Windows
- POSIX :: Linux
Programming Language
- Python :: 3.10
- Python :: 3.11
- Python :: 3.12
- Python :: 3.13
Adapters
There are two major adapter types: base and sql.
base
BaseAdapter defines the base functionality an adapter is required to implement in order to function with dbt-core.
There are several methods which have default implementations as well as methods that require the concrete adapter to implement them.
sql
SQLAdapter inherits from BaseAdapter, updates default implementations to work with SQL-based platforms,
and defines additional required methods to support those defaults.
Components
An adapter is composed of several components.
- connections
- dialect
- relation caching
- integration with
dbt-core
The first two are platform-specific and require significant implementation in a concrete adapter.
The last two are largely implemented in dbt-adapters with minor adjustments in a concrete adapter.
Connections
This component is responsible for creating and managing connections to storage and compute.
Files
dbt/adapters/{base|sql}/connections.py
Dialect
This component is responsible for translating a request from dbt-core into a specific set of actions on the platform.
Files
dbt/adapters/base/column.pydbt/adapters/base/query_headers.pydbt/adapters/base/relation.pydbt/adapters/relation_configs/*dbt/adapters/clients/jinja.pydbt/include/global_project/*
Relation caching
This component is responsible for managing a local cache of relations, relation metadata, and dependencies between relations.
Files
dbt/adapters/cache.py
Integration with dbt-core
This component is responsible for managing the interface between dbt-core and a concrete adapter.
Files
dbt/adapters/{base|sql}/impl.pydbt/adapters/base/meta.pydbt/adapters/base/plugin.pydbt/adapters/capability.pydbt/adapters/factory.pydbt/adapters/protocol.pydbt/adapters/contracts/*dbt/adapters/events/*dbt/adapters/exceptions/*
