Question

A data engineer manages a QuickSight dashboard backed by a SPICE dataset that ingests from an Athena query. The scheduled daily SPICE refresh has started failing, and business users report the dashboard shows yesterday's data. The engineer needs to identify the most efficient first step to diagnose why the refresh is failing without changing the dashboard configuration. What should the engineer do?

Accepted Answer

Review the SPICE ingestion (dataset) refresh history in QuickSight to read the specific error message returned for the failed refresh run.

Answer

Delete and recreate the SPICE dataset to force a full re-ingestion of the Athena results.

Answer

Switch the dataset from SPICE to direct query mode so the dashboard always reflects live Athena results.

Answer

Increase the SPICE capacity purchase in the account to ensure the refresh has enough room to complete.