Redash - Deleted Requests Still Showing

**Describe the bug in current situation**
We had been receiving reports that the numbers returned in the TRA dashboard, are not consistent with the active request count in the mod platform.

After some investigation, it was determined that the requests in question may have been created in AXIS, and pulled into the data warehouse overnight, and later deleted from AXIS. It appears that when a request is deleted from AXIS, it is not being removed from the data warehouse, this is causing an inaccurate reporting figure for active FOI Requests.

**Link bug to the User Story**

**Impact of this bug**
Will present an inaccurate picture of current active requests

**Chance of Occurring (high/medium/low/very low)**
Low - in order for bug to happen, a request needs to be created in AXIS in error, and pulled into the request warehouse with the overnight data pull. The request then has to be deleted after it has been pulled into the warehouse.

The two requests in the data warehouse, that were deleted from AXIS, but still returning as active TRAN requests are: TRA-2023-30520, and TRA-2023-30868

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

**Steps to Reproduce**
Steps to reproduce the behavior:
1. Create Request in AXIS
2. Have request pulled into reporting application - confirm it is showing
3. Delete Request from AXIS
4. Await next refresh, confirm request is still present

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

No files, tests, or entry points are identified in the issue. Start by tracing the overnight AXIS-to-data-warehouse refresh and the handling of TRA-2023-30520 and TRA-2023-30868; done means requests deleted from AXIS no longer appear as active after the next refresh.

Written by the indexing model from the issue text.