Amazon QuickSight CLI to schedule hourly ingestion


Is there a way in Amazon QuickSight to schedule hourly data set refresh via AWS CLI?

asked 2 years ago291 views
1 Answer
Accepted Answer

Apart from the SPICE scheduled refresh from UI, you can use the create-ingestion CLI to perform manual refresh

Get the dataset id using list-data-sets API

aws quicksight list-data-sets --aws-account-id 1231 --region us-east-1

Create a ingestion to SPICE on-demand and use unique ingestion id every time you run this command:

aws quicksight create-ingestion --data-set-id abc1213131 --ingestion-id xyzab111 --aws-account-id 1231 --region us-east-1

Retrieve status:

aws quicksight describe-ingestion --data-set-id abc1213131 --ingestion-id xyzab111 --aws-account-id 1231 --region us-east-1

Note you can only run create-ingestion 24 times a day.

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions