Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Task]: Delivery Dashboard - Create analytics postgres database #1535

Closed
coilysiren opened this issue Mar 25, 2024 · 0 comments · Fixed by #1536
Closed

[Task]: Delivery Dashboard - Create analytics postgres database #1535

coilysiren opened this issue Mar 25, 2024 · 0 comments · Fixed by #1536
Assignees
@coilysiren
Labels
project: grants.gov Grants.gov Modernization tickets

Comments

@coilysiren
Copy link
Collaborator

Summary

Create a new postgres database specifically for being used in analytics processes

Acceptance criteria

No response
@coilysiren coilysiren added the project: grants.gov Grants.gov Modernization tickets label Mar 25, 2024
@coilysiren coilysiren added this to the Delivery dashboard - Infrastructure milestone Mar 25, 2024
@coilysiren coilysiren self-assigned this Mar 25, 2024
@coilysiren coilysiren mentioned this issue Mar 25, 2024
Merged
coilysiren added a commit that referenced this issue Mar 25, 2024
@coilysiren
[Issue #1535] Adds analytics postgres DB (#1536)
bbb656b 
## Summary

Fixes #1535

### Time to review: __5 mins__

## Changes proposed

- Creates the new application folder: `infra/analytics`
- Adds the app-config / env-config for the new application folder,
mostly copy-pasted
- Adds `infra/analytics/database/main.tf`, which creates the database

## Notes for Reviewers

This PR contains a lot of boilerplate because of needing the app-config
/ env-config changes. Sorry for the noise!

## Caveats

The new analytics database module has the same security group rules as
the old one, which will likely become confusing over time. For example,
the new analytics database module has an ingress rule for the Oracle
database... which it definitely does not need. We should pull those
concerns apart over time.

## Testing

<img width="829" alt="image"
src="https://github.com/HHS/simpler-grants-gov/assets/5768468/12cf741e-a0b1-40a1-bb34-09c8c70081ff">
@acouch acouch mentioned this issue Apr 3, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@coilysiren coilysiren

Labels
project: grants.gov Grants.gov Modernization tickets
Projects
Simpler.Grants.gov Product Backlog
Archived in project
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[Issue #1535] Adds analytics postgres DB HHS/simpler-grants-gov
1 participant
@coilysiren