Upgrading to v1.1
Resources
What to know before upgrading
There are no breaking changes for code in dbt projects and packages. We are committed to providing backwards compatibility for all versions 1.x. If you encounter an error upon upgrading, please let us know by opening an issue.
For maintainers of adapter plugins
We have reworked the testing suite for adapter plugin functionality. For details on the new testing suite, refer to the "Test your adapter" step in the Build, test, document, and promote adapters guide.
The abstract methods get_response
and execute
now only return connection.AdapterReponse
in type hints. Previously, they could return a string. We encourage you to update your methods to return an object of class AdapterResponse
, or implement a subclass specific to your adapter. This also gives you the opportunity to add fields specific to your adapter's query execution, such as rows_affected
or bytes_processed
.
For consumers of dbt artifacts (metadata)
The manifest schema version will be updated to v5. The only change is to the default value of config
for parsed nodes.
For users of state-based functionality, such as the state:modified
selector, recall that:
The
--state
artifacts must be of schema versions that are compatible with the currently running dbt version.
If you have two jobs, whereby one job compares or defers to artifacts produced by the other, you'll need to upgrade both at the same time. If there's a mismatch, dbt will alert you with this error message:
Expected a schema version of "https://schemas.getdbt.com/dbt/manifest/v5.json" in <state-path>/manifest.json, but found "https://schemas.getdbt.com/dbt/manifest/v4.json". Are you running with a different version of dbt?
New and changed documentation
Incremental models can now accept a list of multiple columns as their unique_key
, for models that need a combination of columns to uniquely identify each row. This is supported by the most common data warehouses, for incremental strategies that make use of the unique_key
config (merge
and delete+insert
).
Generic tests can define custom names. This is useful to "prettify" the synthetic name that dbt applies automatically. It's needed to disambiguate the case when the same generic test is defined multiple times with different configurations.
Sources can define configuration inline with other .yml
properties, just like other resource types. The only supported config is enabled
; you can use this to dynamically enable/disable sources based on environment or package variables.
Advanced and experimental functionality
Fresh Rebuilds. There's a new experimental selection method in town: source_status:fresher
. Much like the state:
and result
methods, the goal is to use dbt metadata to run your DAG more efficiently. If dbt has access to previous and current results of dbt source freshness
(the sources.json
artifact), dbt can compare them to determine which sources have loaded new data, and select only resources downstream of "fresher" sources. Read more in Understanding State and CI/CD in dbt Cloud.
dbt-Jinja functions have a new landing page, and two new members:
print
exposes the Pythonprint()
function. It can be used as an alternative tolog()
, and together with theQUIET
config, for advanced macro-driven workflows.selected_resources
exposes, at runtime, the list of DAG nodes selected by the current task.
Global configs include some new additions:
QUIET
andNO_PRINT
, to control which log messages dbt prints to terminal output. For use in advanced macro-driven workflows, such as codegen.CACHE_SELECTED_ONLY
is an experimental config that can significantly speed up dbt's start-of-run preparations, in cases where you're running only a few models from a large project that manages many schemas.
For users of specific adapters
dbt-bigquery added Support for finer-grained configuration of query timeout and retry when defining your connection profile.
dbt-spark added support for a session
connection method, for use with a pySpark session, to support rapid iteration when developing advanced or experimental functionality. This connection method is not recommended for new users, and it is not supported in dbt Cloud.
Dependencies
Python compatibility: dbt Core officially supports Python 3.10