Redash not pulling TIC data from data warehouse
- Dominant language
- Python
- Stars
- 8
- Forks
- 2
- Avg merge
- 14h 34m
- Merged PRs (30d)
- 46
Description
**Describe the bug in current situation**
Transportation Investment Corp. (TIC) queries aren't pulling any AXIS data - see [TIC Dashboard](https://reports.foirequests.gov.bc.ca/dashboards/102-combined-ministry-dashboard---tic?p_Analyst=%5B%22All%22%5D&p_Applicant%20Type=%5B%22All%22%5D&p_Category%20By=type&p_Division=%5B%22All%22%5D&p_Divisional%20Stage=%5B%22All%22%5D&p_End%20FQtr=%5B%22All%22%5D&p_End%20FYr=%5B%2220232024%22%5D&p_Overdue%20Status=%5B%22Active%22%2C%22Overdue%22%2C%22Closed%22%5D&p_Request%20State=%5B%22All%22%5D&p_Sector=%5B%22All%22%5D&p_Start%20Date=1990-01-01--2023-12-31&p_Start%20FYr=%5B%22All%22%5D&p_Start%20Month=%5B%22All%22%5D&p_Type=%5B%22General%22%2C%22Personal%22%5D). It doesn't appear that we are getting any data from any of our tables for this org code from foi_edw database.
**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?**
**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 with the linked TIC Dashboard and compare its AXIS results with the foi_edw tables for the organization code. Confirm whether the problem is missing source data or dashboard retrieval, then document the failing query or table and expected result. The issue provides no repository file, test, or reproducible steps.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- data, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100