-
Notifications
You must be signed in to change notification settings - Fork 4
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Overall dbt-synthea layout #29
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I'd like to suggest an overall layout that works well for our OMOP project. For the highest level for models would look like this:
At the individual OMOP table level, It would look like this:
The _Sources_TS folder is where we store the dbt "stage" tables (although we use that for something else)
The "pull" folder holds the models based on the source tables. This is the only folder where source tables and fields are referenced. Also, as much formatting and aggregation and such is done here. All fields will be aliased to OMOP standard field names.
The "stage" level does all the joining to other OMOP tables like Concept, Source_To_Concept_Map Person, and so forth
-- The _ephemeral subfolder holds any subordinate models.
So, the entire layout for drug_exposure looks like this:
The text was updated successfully, but these errors were encountered: