[Core feature] Cleanup feature in Flyteadmin to automatically cleanup database when records older than X

[RRap0so]

Motivation: Why do you think this is important?

Right now our Db keeps piling up the tasks and growing massively, it would be great to have a feature in place where flyteadmin would only keep X amount of days of executions.

Goal: What should the final outcome look like, ideally?

Flyteadmin clears the database records via command.

For example: flyteadmin cleanup -d 90

This command can then be used via Cron daily.

Describe alternatives you've considered

Scripts outside flyteadmin but would be better to have this builtin to leverage all the repository interface code already done.

Propose: Link/Inline OR Additional context

No response

Are you sure this issue hasn't been raised already?

• [X] Yes

Have you read the Code of Conduct?

• [X] Yes

[welcome[bot]]

Thank you for opening your first issue here! 🛠

[RRap0so]

WIP https://github.com/flyteorg/flyteadmin/pull/467