usaspending-api
usaspending-api copied to clipboard
Ftr/pipe 311 sam recipient load table from brokerdb
Description: Add support to load the sam_recipient table from broker to load_query_to_delta.py
Technical details: The high level tech approach for this story is to create a jdbc proxy view on the broker database sam_recipient table. Once this view has been created, SQL very similar to that in the existing restock_duns.sql file can be used to transform the data into the required schema. Requirements for PR merge:
- [x] Unit & integration tests updated
- [x] API documentation updated
- [x] Necessary PR reviewers:
- [x] Backend
- [ ] Frontend <OPTIONAL>
- [ ] Operations <OPTIONAL>
- [ ] Domain Expert <OPTIONAL>
- [x] Matview impact assessment completed
- [x] Frontend impact assessment completed
- [x] Data validation completed
- [x] Appropriate Operations ticket(s) created
- [x] Jira Ticket PIPE-311:
- [x] Link to this Pull-Request
- [x] Performance evaluation of affected (API | Script | Download)
- [ ] Before / After data comparison
Area for explaining above N/A when needed: