[Bug] Issue in doing yaml refactor for Struct column

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

[Bug] Issue in doing yaml refactor for Struct column #134

Open prateek-infoobjects opened 3 months ago

prateek-infoobjects commented 3 months ago

We are currently using DBT with snowflake. While running the dbt-osmosis yaml refactor command for a particular model, we are getting "Could not interpret data_type" error. Exact error is mentioned in the comment

Does it work for Object/Struct columns? If yes, is this a bug?

prateek-infoobjects commented 3 months ago

here is the image

z3z1ma commented 1 month ago

SF object columns were never designed for. We ultimately just rely on dbts unnest property being present and truthy as it is on bigquery structs for example. Would require someone using the dbt snowflake adapter to investigate.