search

fedspendingtransparency / usaspending-api

Server application to serve U.S. federal spending data via a RESTful API
https://www.usaspending.gov
Creative Commons Zero v1.0 Universal
309 stars 112 forks source link

[DEV-10910][DEV-10911] Update columns on covid_faba_spending table #4130

Closed aguest-kc closed 4 months ago

aguest-kc commented 4 months ago

Description: Rename the DEFC column to defc and allow award_types to be null. These changes allow the table to be created, populated and then refreshed from Databricks.

Technical details: Rename the DEFC column to defc and allow award_types to be null. These changes allow the table to be created, populated and then refreshed from Databricks.

Requirements for PR merge:

  1. [ ] Necessary PR reviewers:
    • [ ] Backend
  2. [x] Data validation completed
  3. [x] Appropriate Operations ticket(s) created
  4. [x] Jira Ticket DEV-10910 & DEV-10911:
    • [x] Link to this Pull-Request
    • [x] Performance evaluation of affected (API | Script | Download)
    • [x] Before / After data comparison

Area for explaining above N/A when needed:

1. Unit & integration tests updated
There are already tests that import and test the `TABLE_SPEC` that was updated as part of this change.

2. API documentation updated
No API contracts are affected by this change.

4. Matview impact assessment completed
No matviews are affected by this change.

5. Frontend impact assessment completed
The frontend is not impacted by this change.