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
