search

OHDSI / dbt-synthea

[Under development] A dbt ETL project to convert a Synthea synthetic data set into the OMOP CDM
Apache License 2.0
9 stars 3 forks source link

Contribution #1

Open rjimenezhsc opened 8 months ago

rjimenezhsc commented 8 months ago

Howdy!

I was working on something similar at work and was wondering if maybe we can contribute to this repo.

I'm pretty new to dbt and Synthea, but willing to help where I can :)

One thing that helps is to document the source/staging models and generate schema documentation which can then be hosted on GitHub pages.

Thanks for your time.

vvcb commented 7 months ago

@katy-sadowski @leeevans - This is awesome to see coming together.

Our entire ELT from our multiple EPR sources into OMOP has been done using dbt and the docs are published here https://omop-lsc.surge.sh/. Our poster on this work at the Global OHDSI Symposium 2023 can be viewed here -> https://www.ohdsi.org/2023showcase-20/

While this work does not necessarily transfer to other places, we have learnt a lot through this experience and happy to share our learnings as well as learn from this work.

We are currently working on our OMOP medallion architecture - essentially taking our OMOP instance through bronze, silver and gold layers - with silver serving direct care needs and gold serving research needs. This maybe useful for others but this is very early work still -> https://github.com/lsc-sde/dbt_omop_rxn_silver/

Looking forward to seeing more dbt related work within OHDSI.

katy-sadowski commented 7 months ago

Hello friends! I am so happy to see your enthusiasm for dbt as we get this project off the ground. Thank you for your comments 🤩

Regarding contribution in general, we'd certainly love help. The prerequisites for pitching in are:

If this sounds like you, please feel free to send me an email at sadowski@ohdsi.org and I can loop you into planning talks.

@vvcb - Good to meet you; I know your work! It's on a list of inspirations we will certainly be drawing from for this project. We'd love to learn from you and your team directly, too. Please do reach out to me if you're interested in setting up a chat.