What is parsing?
At the start of every dbt invocation, dbt reads all the files in your project, extracts information, and constructs a manifest containing every object (model, source, macro, etc). Among other things, dbt uses the
config() macro calls within models to set properties, infer dependencies, and construct your project's DAG.
Parsing projects can be slow, especially as projects get bigger—hundreds of models, thousands of files—which is frustrating in development. There are a handful of ways to optimize dbt performance today:
- LibYAML bindings for PyYAML
- Partial parsing, which avoids re-parsing unchanged files between invocations
- An experimental parser, which extracts information from simple models much more quickly
- RPC server, which keeps a manifest in memory, and re-parses the project at server startup/hangup
These optimizations can be used in combination to reduce parse time from minutes to seconds. At the same time, each has some known limitations, so they are disabled by default.
PyYAML + LibYAML
dbt uses PyYAML to read and validate YAML files in your project. PyYAML is written in pure Python, but it can leverage LibYAML (written in C, much faster) if it's available in your system. Whenever it parses your project, dbt will always check first to see if LibYAML is available.
You can test to see if LibYAML is installed by running this command in the environment where you've installed dbt:
python -c "from yaml import CLoader"
After parsing your project, dbt stores an internal project manifest in a file called
partial_parse.msgpack. When partial parsing is enabled, dbt will use that internal manifest to determine which files have been changed (if any) since it last parsed the project. Then, it will only parse the changed files, or files related those changes.
Starting in v1.0, partial parsing is on by default. In development, partial parsing can significantly reduce the time spent waiting at the start of a run, which translates to faster dev cycles and iteration.
PARTIAL_PARSE global config can be enabled or disabled via
profiles.yml, environment variable, or CLI flag.
Parse-time attributes (dependencies, configs, and resource properties) are resolved using the parse-time context. When partial parsing is enabled, and certain context variables change, those attributes will not be re-resolved, and are likely to become stale.
Anything that is re-rendered at execution time, such as model SQL or nested hooks, will always use the latest execution context, and will therefore be correct.
In particular, you may see incorrect results due to:
- A change in environment variables. Files which depend on
env_varfor parse-time attributes (dependencies and configs) may be incorrect in subsequent parses/invocations if env vars have changed.
- "Volatile" Jinja variables, such as
invocation_id, or flags, that are likely (or guaranteed!) to change in each invocation. We highly discourage you from using these variables to set parse-time attributes (dependencies, configs, and resource properties).
If certain inputs change between runs, dbt will trigger a full re-parse. The results will be correct but slow. Today those inputs are:
- installed packages
- dbt version
- certain widely-used macros, e.g. builtins overrides or
If you ever get into a bad state, you can disable partial parsing and trigger a full re-parse by setting the
PARTIAL_PARSE global config to false, or by deleting
target/partial_parse.msgpack (e.g. by running
At parse time, dbt needs to extract the contents of
config() from all models in the project. Traditionally, dbt has extracted those values by rendering the Jinja in every model file, which can be slow. In v0.20, we introduced a new way to statically analyze model files, leveraging
tree-sitter, which we're calling an "experimental parser". You can see the code for an initial Jinja2 grammar here.
Starting in v1.0, the experimental parser is on by default. We believe it can offer some speedup to 95% of projects. You may optionally turn it off using the
STATIC_PARSER global config.
For now, the static parser only works with models, and models whose Jinja is limited to those three special macros (
config). The experimental parser is at least 3x faster than a full Jinja render. Based on testing with data from dbt Cloud, we believe the current grammar can statically parse 60% of models in the wild. So for the average project, we'd hope to see a 40% speedup in the model parser.
We plan to make iterative improvements to static parsing in future versions, and to use random sampling (via anonymous usage tracking) to verify that it yields correct results. You can opt into the latest "experimental" version of the static parser using the
USE_EXPERIMENTAL_PARSER global config.