GSA-TTS / FAC

GSA's Federal Audit Clearinghouse
Other
19 stars 5 forks source link

Analysis of Data Discrepancy between Preview and Census S3 #3954

Closed gsa-suk closed 3 months ago

gsa-suk commented 3 months ago

Some of the errors observed during migration tests with Preview data did not occur with migration tests on Matt J's computer. Initial queries of elecauditheader table indicate that there are rows with blank ELECAUDITHEADERID in Preview, whereas there were no such rows in Matt J's db. Analyze the data discrepancy. Note: Matt J used the data from Census S3 bucket.

gsa-suk commented 3 months ago

Analysis document - https://docs.google.com/document/d/1FkBq3OlCb1ZZpadw9K_cyaMkh-lICDGAB11W8hxnDbI/edit