Sage-Bionetworks / sage-monorepo

Where OpenChallenges, Schematic, and other Sage open source apps are built
https://sage-bionetworks.github.io/sage-monorepo/
Apache License 2.0
21 stars 12 forks source link

[Task] Generate monthly reports on OC data updates #2645

Open tschaffter opened 2 months ago

tschaffter commented 2 months ago

What product(s) is this story for?

OpenChallenges

As a user, I want

As a Product Owner, I want to get a summary of the OC data that have been created or changed so that I can share this summary with stakeholders.

Description

One approach would be to create SQL queries that can be run against the OC DB. This query could then continue to be used when the DB has been migrated to an AWS managed DB.

Alternatively, we could create an endpoint to access these data to enable anyone to fetch them.

Acceptance criteria

The following metrics can be generated for an arbitrary period of time defined by two datetimes:

Tasks

No response

Anything else?

No response

Have you linked this story to a GitHub Project?