z3z1ma / dbt-osmosis

Provides automated YAML management, a dbt server, streamlit workbench, and git-integrated dbt model output diff tools
https://z3z1ma.github.io/dbt-osmosis/
Apache License 2.0
422 stars 46 forks source link

feat: load column description from db. #120

Closed yassun7010 closed 6 months ago

yassun7010 commented 6 months ago

dbt does not officially support column comments in Column class. Therefore, the column description in sources of schema.yml generated from database information is always empty.

However, if a database adapter supports column comments, we will give you the ability to add column comments. I will work to get dbt-core to support this feature.

It would be great if dbt-osmosis would automatically fetch comments from the database when we add a source name to schema.yml.

What do you think about this?

yassun7010 commented 6 months ago

Refer dbt-labs/dbt-core/issues/9198

z3z1ma commented 6 months ago

LGTM, nice feature!