bcgov / bcgov/entity

Update pipeline to support Financial Institution Tombstone Data

Open
#25,606 0 comments 0 reactions 0 assignees View on GitHub
COBRS
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

This ticket is to update the pipeline to support Financial Institution Tombstone Data.

This will include:
* Updating raw sql queries to pull in required data from COBRS db extract
* Updating code to generating filing json for given filing
* Update custom filer code to process generated filing json
* Testing pipeline against a decent sample size to see what errors come up

When updating the pipeline to support a given filing, the initial testing will be done locally against a COBRS db extract.

In our overall migration testing, all migration of prod COBRS corp data will be tested. Under this comprehensive testing, various data issues and edge cases will be discovered for various filings. We will cut tickets at this time to address the issues that come up.

NOTE: Before data can be loaded into an environment, there must be a robust facility to delete that data from the environment into which it was loaded.

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are named. Start by locating the raw SQL queries, filing JSON generation, and custom filer code, then run the pipeline locally against a COBRS database extract. Done means the pipeline supports Financial Institution Tombstone Data, handles a representative sample, and includes a robust way to delete loaded data.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
backend, data, database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.