🐛 [firestore-bigquery-export] Pruning old enough changelogs periodically, except those remaining in the latest view.

[RyosukeNishi]

[READ] Step 1: Are you in the right place?

Issues filed here should be about a feature request for a specific extension in this repository. To file a feature request that affects multiple extensions or the Firebase Extensions platform, please reach out to Firebase support directly.

[REQUIRED] Step 2: Extension name

This feature request is for extension: firestore-bigquery-export

What feature would you like to see?

I'd want a feature that periodically prune old enough changelogs, whose timestamp is like more than 30 days ago for example, except those remaining in the latest view.

How would you use it?

Currently, I'm using the changelog table as a source of PITR (you know, you can get a snapshot at any point in time just by filtering the table with timestamp). Unless you need an infinite period of PITR window, you want to prune old changelogs periodically to save the storage costs. Though you can do it manually at the moment, it would be better if the extension would do it on behalf of you.