Create empty source_to_concept_map model instead of seeding it

OHDSI / dbt-synthea

[Under development] A dbt ETL project to convert a Synthea synthetic data set into the OMOP CDM

https://ohdsi.github.io/dbt-synthea/

Apache License 2.0

16 stars 6 forks source link

Create empty source_to_concept_map model instead of seeding it #95

Closed katy-sadowski closed 2 weeks ago

katy-sadowski commented 3 weeks ago

Right now, the seed vocab includes an empty STCM table, and BYO data mode has no handling of this table (other than an assumption the user will bring their own empty table). This can cause an error in BYO mode in Postgres if the user didn't load this table.

Since we're not using the table in this project yet, for now we should just create an empty one as an omop model and remove the empty seed and stg model.

lawrenceadams commented 3 weeks ago

Had the same problem in snowflake - good catch!