You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ETL-Synthea truncates datetimes to dates, so not an issue there. It's possible it doesn't make sense to join on a timestamp. Need to look in the data to confirm.
Also, the issues in #47 turned out to be related to ordering of visit events by date vs datetime.
The text was updated successfully, but these errors were encountered:
katy-sadowski
changed the title
Potentially join on date instead of datetime for condition costs
Investigate use of dates vs timestamps for intermediate entity derivation / de-duping logic
Dec 2, 2024
For example, condition costs are identified via a join on date time right now; maybe this should be date?
dbt-synthea/models/intermediate/int__cost_condition.sql
Line 44 in ae79114
ETL-Synthea truncates datetimes to dates, so not an issue there. It's possible it doesn't make sense to join on a timestamp. Need to look in the data to confirm.
Also, the issues in #47 turned out to be related to ordering of visit events by date vs datetime.
The text was updated successfully, but these errors were encountered: