I want to export data from mongodb automatically, and upload to S3 Bucket, and create a pre-signed url to then send to stakeholders.
In my production project, the clients wants weekly updates on DB. I am ssh tunnelling into a server, then connecting to Mongodb via connection string, then exporting data from MongoDB manually with some specific fields to JSON, then converting to CSV.
I then open up Cyberduck and connect to S3 Bucket, I upload to the s3 bucket and right click on the file and copy a presigned version which means the link will expire and then provide the link to the client.
Is there a way I can make this faster and/or automated completely?