Question

A data engineering team publishes several QuickSight dashboards backed by SPICE datasets that refresh nightly from Amazon Athena. Over the past week, business users report that some dashboards show data that is two days old. The engineer confirms the scheduled refresh jobs are configured correctly and the underlying Athena tables have fresh data. What is the MOST likely cause of the stale dashboards, and how should the engineer confirm it?

Accepted Answer

The SPICE capacity for the account/region is exhausted, causing refreshes to fail; check the SPICE capacity usage and the dataset refresh history for failed ingestions.

Answer

Athena workgroup query result location is misconfigured; check the S3 output bucket permissions for the dashboard viewers.

Answer

Row-level security rules are blocking new rows; review the RLS dataset and remove restrictions for affected users.

Answer

The dashboards are set to direct query mode; switch them to SPICE to enable scheduled refreshes.