bcgov / bcgov/foi-flow

PROD Redash - Unable to get updated divisions through query

Open
#4,607 0 comments 0 reactions 0 assignees View on GitHub
bug low priority
Dominant language
Python
Stars
8
Forks
2
Avg merge
14h 34m
Merged PRs (30d)
46

Description

**Describe the bug in current situation**
'Divisions' query ("Performance Dashboard -Division - xxx") in Redash unable to get updated data from data warehouse. See "Performance Dashboard -Division - MOE" as example.

![image](https://github.com/bcgov/foi-flow/assets/117312323/ba81e42f-7901-466a-840a-8832837d30dd)

**Link bug to the User Story**

**Impact of this bug**
Describe the impact, i.e. what the impact is, and number of users impacted.

**Chance of Occurring (high/medium/low/very low)**

**Pre Conditions: which Env, any pre-requesites or assumptions to execute steps?**
PROD

**Steps to Reproduce**
Steps to reproduce the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

**Actual/ observed behaviour/ results**

**Expected behaviour**
A clear and concise description of what you expected to happen. Use the gherking language.

**Screenshots/ Visual Reference/ Source**
If applicable, add screenshots to help explain your problem. You an use screengrab.

Contributor guide

Open the contributing guide

Research direction

Start in the PROD Redash query named "Performance Dashboard -Division - MOE" and compare its results with the data warehouse's current divisions. Reproduce the missing updates in PROD, then confirm the query returns the updated division data and check comparable "Performance Dashboard -Division - xxx" queries.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.