The problem I’m having
The dbt project has many models that draw columns from a ref() model without any column renaming or transformations. Rather than retyping doc blocks '{{ doc("my_column") }}'(or hardcoded text) in description for every column in downstream models, I would like columns to inherit the description (and only the description) from upstream models.
The context of why I’m trying to do this
We use dbt core (not dbt cloud).
Ideally, the furthest upstream model description would draw on a docs blocks file, and then all downstream models would inherit this.
What I’ve already tried
- A post indicated that dbt-osmosis can be used for this. After reading the docs, it’s not clear to me how to implement dbt-osmosis to just propagate column documentation (without additional functionality).
Thank you!