bcgov / bcgov/foi-flow

Redash not pulling TIC data from data warehouse

Open
#4,587 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**
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.