PROD Redash - Unable to get updated divisions through query
- 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.

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