Feature Request: data types added to columns in .yml

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 45 forks source link

Feature Request: data types added to columns in .yml #71

Closed connor-lough closed 10 months ago

connor-lough commented 1 year ago

With the new constraints feature in dbt 1.5, you can enable constraints. However, unlike the dbt_constraints package (by Snowflake), with dbt's 1.5 constraints you un/fortunately have to enable contracts which requires listing out every column and its data type. dbt-osmosis already goes into Snowflake INFORMATION_SCHEMA to reorder columns, it'd be great if it could add in data types!

connor-lough commented 1 year ago

Going to take a stab at this myself. Will keep issue thread updated.

nurikk-sa commented 10 months ago

Hi @connor-lough! Do you still work on this feature?