lms
lms copied to clipboard
Sync the organization activity report to another region
Requires:
- https://github.com/hypothesis/lms/issues/4516
In the previous ticket a report was created in a single region for organization activity. We need to make sure that this report will show up in another regional Metabase without manual work.
This needs to:
- Have the same name and appear in the same place in the interface for Metabase (if it's in a dash or landing page etc.)
- Read from the appropriate regional DB
- Be automatically synced
- Be updatable on demand using a pipeline of some kind
Tasks
- [ ] Create the correct instance of Metabase for this region (if we are using a single box this might already be done)
- [ ] Deploy all the required aggregates and views (if we haven't already)
- [ ] Demonstrate a sync between the two machines
- [ ] Have this run by a CI/CD pipeline