Is 'enhance Amazon Quick Suite dashboards with on-demand data refresh' also applicable if SPICE dataset was loaded from Redshift?

Yes, the on-demand data refresh solution for Amazon Quick Suite dashboards is applicable when your SPICE dataset is loaded from Amazon Redshift. The solution is specifically designed to work with SPICE datasets that ingest data from various supported sources, including Amazon Redshift, Amazon RDS, Amazon Athena, and Amazon S3.

The on-demand refresh capability allows users to trigger dataset updates directly from the dashboard at critical moments when immediate data updates are needed, rather than waiting for scheduled refreshes. This works by using an API Gateway endpoint and Lambda function that calls Quick Suite's CreateIngestion API to trigger a SPICE ingestion refresh for your dataset, regardless of whether the underlying data source is Redshift or another supported source.

This approach is particularly useful when you need to maintain high-performance dashboards while ensuring the data reflects the most recent updates from your Redshift data warehouse, giving end-users direct control over when data is refreshed beyond the baseline scheduled refreshes.
Sources
Enhance Amazon Quick Suite dashboards with on-demand data refresh | AWS Business Intelligence Blog