usaspending-api

usaspending-api copied to clipboard

**Description:** Initial delta model for rpt.subaward_search and configuration to populate it via `load_query_to_delta` **Technical details:** * Split out subawards from `test_load_to_from_delta` **Requirements for PR merge:** 1. [x] Unit & integration...

dpb-bah

**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...

bkschmidt

**Description:** Adapts the `restock_recipient_profile` sql script to wirk in databricks. **Requirements for PR merge:** 1. [X] Unit & integration tests updated 2. [X] API documentation updated 3. [ ] Necessary...

emily-brents

[PIPE-315] Implement Recipient Lookup ETL with Spark

1

**Description:** Implemented Recipient Lookup with Spark and made updates to test cases. **Technical details:** * Implemented the Recipient Lookup ETL which required increasing the allocated memory in the MAKE command...

sethstoudenmier

**Description:** Create Lakehouse tables for prepared reporting data (gold data zone) and optimize schema, transaction log, and data retention **Technical details:** Empty summary_state_view table exists in the rpt schema in...

bkschmidt

[/api/v2/search/spending_by_category/county/] state missing

1

How can I know which state that county belongs to since there are so many duplications of name. I request the API with [/api/v2/search/spending_by_category/county/] but found there is no mark...

peijin0405

I maintain a REDCap-based program that was using the Federal RePORTER to match grant awards with PI (and Co-PI) names and institutions. We have queried by name and institution to...

scottjpearson

[DEV-8395] Travis CI based on our docker-compose.yaml services

1

**Description** Make sure Travis CI workloads and our local dev env workloads (and tests in each) are all using the same config and setup so they pass and fail the...

kwhickey

When attempting to build the image from the Dockerfile, I receive a error when it tries to download PostgreSQL. ---------------------- > [ 6/19] RUN yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm: #9 1.540...

dc-steph

Shouldn't this information be in the duns table? (Is there a legal reason why annual revenue is only on transactions?)

pllearns