You can use the describe ingestion to see if it is successful.
https://docs.aws.amazon.com/cli/latest/reference/quicksight/describe-ingestion.html
However, I don’t know if you can do this with like versioning of the dataset.
If you have an embedded application, there could be more logic to this and might work.
I think it might look like this. You have two dashboards using two different datasets. The first one tries the ingestion and checks the first dataset. If it works then continue to use the first dashboard. If it doesn’t work use the second dataset.
Then on the next hour, check the status again. If it works then display the first dashboard and update the second dataset. Else use the second dataset.
Something like that might work. I don’t think it will work via the QuickSight console.