Standardize ad-hoc change process (2 weeks)
Centralize data query access (2 weeks)
Integrate SQL review into CI (1 week)
Manage schema migration (4 ~ 8 weeks)
Duration | 2 weeks |
Goals | 1. Remove direct human write access to database. 2. Streamlined change process with review, check, rollout, rollback, notification, and history. |
Duration | 2 weeks |
Goals | 1. Remove direct human read access to database. 2. Access grants are reviewed and recorded. 3. Dynamic masking policy depending on the querier. |
Duration | 1 week |
Goals | 1. Auto check SQL anti-patterns during CI. 2. Non-intrusive to the existing CI pipeline. |
Duration | 4 ~ 8 weeks |
Goals | 1. Decouple schema migration from code release. 2. Streamlined change process with review, check, rollout, rollback, notification, and history. |