Home icon

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.



Go to article

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
Create larger SPICE datasets and refresh data faster in Amazon QuickSight with new SPICE features
Jan 5
2026
Enhance Amazon Quick Suite dashboards with on-demand data refresh
Jan 20
2026
Amazon Quick Suite launches expanded size, faster ingestion, and richer data type support for SPICE datasets
Jul 2
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.