GOLD ETL missing insdc_biosample_identifiers values in biosample_set records

[aclum]

Describe the bug
GOLD ETL code is not populating insdc_biosample_identifiers for EMP 500

To Reproduce
Steps to reproduce the behavior:

1. check json files attached to Ingest remaining 737 biosamples for nmdc:sty-11-547rwq94 (EMP500) issues#940 for insdc_biosample_identifiers, cross reference with GOLD.

Expected behavior
Ex nmdc:bsm-11-48fce216 should have a insdc_biosample_identifiers value of SAMEA7723945

Acceptance Criteria

• json code generated from the gold translator for nmdc:sty-11-547rwq94 generates biosample_set records which have fields for insdc_biosample_identifiers
• if possible determine when the bug was introduced & make tickets to update records if other recently imported studies are impacted.

Additional context
Add any other context about the problem here.

[ssarrafan]

No updates for 2 weeks. Removing from sprint, adding backlog label. @aclum @sujaypatil96

[aclum]

@sujaypatil96 was this resolved?

[sujaypatil96]

@aclum i don't think it was. I'll look into this today and post updates on this issue.

[sujaypatil96]

The JSON file for the remaining 279 biosamples includes the insdc_biosample_identifiers and ahs been fixed generically in the associated PR: EMP500_batch_two_ingest.json

[sujaypatil96]

However, we still need to go back and make a changesheet to add insdc_biosample_identifiers for the 458 samples that we added in the previous ingest.

[sujaypatil96]

You can find the changesheet which updates the insdc_biosample_identifiers and also img_identifiers for some biosamples for which the value is present, on the squad slack channel.

[sujaypatil96]

The same changesheet has been applied to prod Mongo as well. We should see the results on the prod data portal after the next weekly prod portal ingest.