Partial Delete and load - using MongoDb tools

[arunkumark_21]

Hi Awesome Community,

I have around 800-1000 records in a mongo collection perday.

I want to introduce a rerun functionality in my alteryx workflow. Which means, on passing a date parameter all the 8000-10000 records in the collection needed to be deleted and then fresh record to be inserted.

As a workaround I am querying the same collection, removing the records corresponding to that particular date and then unioning with fresh record. But this will be a problem when the collection starts growing.

Is there a cleaner way of doing this?

Like writing a pre-sql  when inserting other DB?

Note: Writing a python/R script may not be a good option as I have to handle the password separately

Thanks,

Arun Kumar