bcgov / bcgov/gwells

Provide Access to GWELLS DB for Service Owner

Open
#1,925 1 comment 0 reactions 0 assignees View on GitHub
Ready User Story
Dominant language
Python
Stars
33
Forks
34
Avg merge
2d 3h
Merged PRs (30d)
6

Description

**As a** *Service Owner* **I want** *to be able to query the DB* **So That** *I can pull data for reports*

**Additional Context**
- We are giving Service Owner access to the DB as she knows how to write SQL queries (for Leia and maybe Uelun)
- This is a short term solution with the long term solution being to implement something like Metabase so more people have access to the data
- Note from Julian in previous ticket (#1845):
"We might run into an issue where files don't carry over between deployments since this was done directly in a pod console not in the bc/dc. So if that happens we will need to figure out how to edit the hba_file config to adjust the rules allowing outside users to port-forward into the database. As well as adding a read only user (to prevent mistakes) for the current SO."

**Acceptance Criteria**
- [ ] Service Owner can query DB
- [ ] Service owner knows what they are not allowed to do in the DB

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with issue #1845 and the deployment configuration, then verify how database access is exposed and whether hba_file changes persist across deployments. Define a read-only access path for the Service Owner, document prohibited database actions, and verify both acceptance criteria.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, devops, security
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.