What is the most efficient way to import a daily CSV with 1 million rows from s3 into an Appian? (On daily basis we have to truncate the table and load the new data).
Discussion posts and replies are publicly visible
Would it be an option to store that data in a database at Amazon and connect that to Appian?
As of now we don't have an option for AWS database.Thank you, I will research how can we integrate with Athena. Never tried. keep you posted how it goes.ever tried to integrate with AWS Glue?
I've never done it personally but you can try using Chat GPT to explain the different steps involved.
Personally I would try the 1st method above and see if it works for before trying the Athena method.
Waiting for the file, once we got it, i will try the first approach and monitor the performance trends.