How to use the comments/descriptions in schema file into the database

Help
,
1

The problem I’m having

I have defined some table and columns descriptions as stated in the documentation. It properly generates the documentation with dbt docs generate. But I would like that when I run the model, when the database allows it, it also store the description with the use of COMMENT ON COLUMN ....

The context of why I’m trying to do this

I am working with dbt 1.7.3 and the database is a postgres.

What I’ve already tried

Using a post-hook, I tried to implement some macro able to read from the schema.yml but apparently I can not/I don’t know howto load any file.

I tried also to know if I can reach the schema within the dbt object data, but I did not find how to do it.

Any one tried this before ?, how could I do it ?

Thanks!

2

Setting persist_docs columns to true should solve it: https://docs.getdbt.com/reference/resource-configs/persist_docs

Note: @rhasenack originally posted this reply in Slack. It might not have transferred perfectly.