Menu
I am looking to refresh a data set in quicksight, this is in Spice. The data set comes from a csv file that has been updated and now has more data than the original file I uploaded.
I can't seem to find a way to simply repoint to the same file with same format. I know how to replace the file but whenever i do this it states that it can't create some of my calculated fields and so drops multiple rows of data!
I assume I'm missing something obvious but I can't seem to find the right method or any help on the issue.
Thanks
640
Here are the steps to get an automatic refresh from the csv file: From a blank work select "From Text" in the "Get External Data" section of the Data tab. Use the Text Import Wizard to set how your csv file will be imported. After you select Finish to exit the Import Wizard, a dialog box titled Import Text will come up ...
The only way to stop a refresh on the quicksight website is to edit the dataset that's currently being refreshed, and to modify it then save it. This will cause the current refresh to fail, and a new one to begin. There is a public API that can cancel an ingestion though.
Editing a dataset from the Datasets pageFrom the QuickSight start page, choose Datasets at left. On the Datasets page that opens, choose the dataset that you want to edit, and then choose Edit dataset at upper right.
Unfortunately, QuickSight doesn't support refreshing file data-sets to my knowledge. One solution, however, is to put your CSV in S3 and refresh from there.
The one gotcha with this approach is that you'll need to create a manifest file pointing to your CSV. This isn't too difficult and the QuickSight documentation is pretty helpful.
197
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
