ULC/CCC/BC pipeline - update to support agm extension
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
This ticket is to update the pipeline to support agm extension.
This will include:
* Updating raw sql queries to pull in required data from COLIN 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 COLIN db extract. We can test with a smaller but significant sample size of fillings to have a certain level of confidence that the pipeline is working in general for a given filing.
In our overall migration testing, all migration of prod COLIN 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.
- [ ] Update corps data pipeline code as required to bring over agm extension filings for ULC/CCC/BCs
- [ ] Run pipeline locally against at least 1000+ filings if possible. It might be hard to do this as you will need to find businesses that have a sequence of consecutive filings that are supported by the pipeline. If it’s too difficult for a given filing to do this, this testing will be covered further downstream when more filings are supported by the pipeline.
- [ ] Cut tickets as required to address larger data or filing issues as discovered. With there being potentially a lot of data issues in COLIN, we may need to cut additional tickets to address specific issues in future tickets.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the corps data pipeline, its raw SQL queries, filing JSON generation, and custom filer processing. Run the pipeline locally against a COLIN database extract and a representative filing sample. Done means AGM extension filings are brought over for ULC/CCC/BCs, with testing completed and follow-up tickets recorded for larger data issues.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, python, sql
- Domain
- backend, data-engineering, databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100