Appending dataset using csv files - data source is multiple csv files with same column names

[royyung]

do you mean that the csv files will be updated in a regular time(e.g. daily)?
for instance, day1.csv has Jan1 data. day2.csv has Jan2 data. Then you want to show all data in QuickSight

If it is the case, you may refer to this approach shared by @darcoli using Athena as data source

Append new .CSV file data?

In the meantime, another simple approach might be to store these csv files in an s3 bucket and add an Athena table reading these files. Then, from QuickSight, use that athena table in your dataset rather than uploading the files there. (Assuming you don’t use Athena partitioning, then newly updated files’ data will immediately be visible to QuickSight - but will need a SPICE refresh if you are using that)