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
Create a process that runs daily that:
1. Downloads the file from S3 (via Amazon S3 Utilities plugin - Amazon S3 Utilities )
2. Imports the CSV into Database (via Excel tools plugin - Excel Tools )
Yeah, That's the option but am thinking about the performance. so looking for other options.
I think it'll be fine personally. Otherwise your other option is to have a service backed record with the method mentioned below.