Recommended approach to update .CSV Dataset - Weekly

I have a .csv file that I receive each week with updated data (PO data with the latest weeks’ data added to previous data set, tracking YTD). Working on getting this auto-fed to a database table to query off automatically in the future. Until this is set-up is there a recommended approach to updating this weekly? Can I just replace the existing file each week and update dashboard view off the latest data? For reference, the columns in the data set will not change only new data (rows) will be added with each update

Hi @mrusnac - Welcome to AWS QuickSight community and thanks for posting the question.
Yes, when you replace the data set manually, the underline analysis and dashboard will be refreshed automatically. You can do a POC with sample csv and test it before implementing to original data set.

Regards - San

2 Likes

Hi @mrusnac - If the above suggestion will work for you, please marked the post as solution so that it will help others in the community :slight_smile:

Regards - San

1 Like

Yes, I will test this out and let you know if it does work. Appreciate your suggestion here.

2 Likes