Closed lawrenceadams closed 6 days ago
Seed column_type hinting is incomplete/incorrect/patchy.
column_type
I think we need to have a blanket approach of providing hints for all types, as dbt can incorrectly interpret these, and may cause issues when trying to support new warehouses in the future.
Furthermore, some referenced columns do not exist, for example imaging studies does not have a CODE column.
https://github.com/OHDSI/dbt-synthea/blob/e65d1f4f9139f7086c99e42d7c6c0eb706d68277/dbt_project.yml#L24-L109
Seed
column_typehinting is incomplete/incorrect/patchy.I think we need to have a blanket approach of providing hints for all types, as dbt can incorrectly interpret these, and may cause issues when trying to support new warehouses in the future.
Furthermore, some referenced columns do not exist, for example imaging studies does not have a CODE column.
https://github.com/OHDSI/dbt-synthea/blob/e65d1f4f9139f7086c99e42d7c6c0eb706d68277/dbt_project.yml#L24-L109