Automate SPICE dataset refreshes using Amazon Quick Sight APIs
Business Intelligence Blog
This article explains how to automate SPICE dataset refreshes in Amazon QuickSight using APIs, covering full and incremental refresh strategies.
- SPICE is QuickSight's query acceleration engine for fast dashboard and report performance
- Full refresh completely replaces datasets; incremental refresh updates only recent data efficiently
- Five APIs manage refresh schedules: create, delete, update, describe, and list operations
- Incremental refresh requires configuring lookback windows on SQL-based data sources first
- Internal checkpoints track refresh timestamps for subsequent incremental refresh calculations
- APIs support programmatic deployment via AWS CLI, SDKs, or infrastructure-as-code tools
- Requires specific IAM permissions for dataset and refresh schedule management
QuickSight's refresh APIs enable automated, scalable management of SPICE dataset updates without manual intervention, supporting both scheduled and on-demand refresh operations.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Nov 17
2021
2021
Create larger SPICE datasets and refresh data faster in Amazon QuickSight with new SPICE features
Jan 5
2026
2026
Enhance Amazon Quick Suite dashboards with on-demand data refresh
Jan 20
2026
2026
Amazon Quick Suite launches expanded size, faster ingestion, and richer data type support for SPICE datasets
Jul 2
2025
2025
Amazon QuickSight supports 2B row SPICE dataset
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.