Investigate dbt test failure

[katy-sadowski]

We have 1 failing test on the seed dataset:

23:51:46 Completed with 1 error and 0 warnings:
23:51:46
23:51:46 Failure in test relationships_stg_synthea__claims_transactions_patient_insurance_id__member_id__ref_stg_synthea__payer_transitions_ (models/staging/synthea/_synthea__models.yml)
23:51:46 Got 4598 results, configured to fail if != 0

The issue seems to be a data issue in Synthea (I had marked member_id as an FK due to the note here: https://github.com/synthetichealth/synthea/wiki/CSV-File-Data-Dictionary#claims-transactions). We should investigate further.

[lawrenceadams]

Doing some digging, it looks like the table ClaimTransition.memberId is defined here, which in term returns the id here.

Following the trail leads us here - the documentation is very vague / plain incorrect, the CSV will yield the patient ID if they have a membership from here

[lawrenceadams]

synthetichealth/synthea#1508 issue raised.