Hi,
are you already using athena or redshift? Otherwise you have to take a look at the costs of these beforehand.
Our setup is S3 → Athena → Quick Sight.
In Quicksight we have the data in Spice.
With SPICE you pay for each reserved GB per month.
If you use direct query with athena, you create a query every time when you interact with the data (refresh, filter, etc). In Athena you pay for read data per TB.
So if the filesize is big it could make sense to load it into Spice. Then you have the cost of one athena query and the monthly cost of SPICE.
I dont have experience with redshift costs, so someone else could tell you something about this.
Then you have the option to load directly from S3 or upload thr file manually to quicksight.