How to append data from S3 Bucket into Domo
I am going to recieve one file daily into my S3 bucket, which I need to bring into Domo through the S3 Advanced Bucket connector. I have to keep historical data in Domo, which means that I have to append mydataset in Domo everyday with a new file that is coming into the S3 bucket daily.
I do not understand how to do this. I'm looking for an option that does not involve any scripting to append files. More specifically, I saw the 'Append' option in the Domo S3 Advanced connector. I'm curious about how Domo will know which file to append into the old data, if there are multiple files in the S3 bucket (old and new).
e.g If there is one file in S3 bucket which came yesterday called "Finances_13_July", and it was imported into Domo through the connector. Next day, a file called "Finances_14_July" comes in the S3 bucket. Will the append option in the Domo S3 Advanced connector realize which file was the old one (already imported into Domo) and which is the new file to be appended (given that both todays and yesterday's file are in the S3 bucket)?