Unable to refresh the dataset in Quicksight. Since morning it’s in loading page. Unable to see the data in dataset using spice.
Hi @Tejasai99
This must be an issue in your database. See if you can run the query in your database and it is able to return values.
There is no problem as such in Quick Sight today.
Regards,
Giri
Hi @Giridhar.Prabhu, thank you for your response.
I just ran the query in Snowflake and its ran good.
Please See the result and response. Database side everything seems good.
Hi @Tejasai99
I don’t see details shared. Can you confirm if the issue still persists. If not shared the details of your checks performed.
Regards
Giri
Hi @Tejasai99,
Hope everything is well! Just checking in since this thread hasn’t received a response in a while. Were you able to see Giridhar.Prabhu’s most recent message and/or was your question resolved? If not, please feel free to message any persistent issues you are facing. If we do not hear back within the next 3 business days, I’ll go ahead and close out of this topic.
Thank you!
Nearly half our datasets were stuck in that state after the AWS outage. I had to run AWS CLI to get a list of all datasets with IngestionStatus = QUEUED (we have scheduled refreshes, so the second-to-last refresh will be “Running” and the latest refresh will be “Queued”. In your case you don’t seem to have scheduled refreshes, so you’d want a list of datasets with IngestionStatus = Running). I had never used AWS CLI before, but Claude is a better resource to figure it out than AWS help documentation. I then had to go into each dataset and manually “Save & Publish”. This seemed to force the refresh and unlock things.