# How to change SPICE refresh from FULL to INCREMENTAL using create-ingestion CLI

**URL:** <https://community.amazonquick.com/t/how-to-change-spice-refresh-from-full-to-incremental-using-create-ingestion-cli/12481>\
**Category:** Q&A\
**Tags:** qls-spice, quick-sight\
**Created:** [April 19, 2023, 10:24pm UTC](https://community.amazonquick.com/t/how-to-change-spice-refresh-from-full-to-incremental-using-create-ingestion-cli/12481 "2023-04-19T22:24:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![koxley](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@koxley](https://community.amazonquick.com/u/koxley)\
**Post date:** [April 19, 2023, 10:24pm UTC](https://community.amazonquick.com/t/how-to-change-spice-refresh-from-full-to-incremental-using-create-ingestion-cli/12481/1 "2023-04-19T22:24:26Z")

</div>

We are currently using a full refresh of our SPICE datasets by using the following CLI:

aws quicksight create-ingestion --aws-account-id 9999999999 --data-set-id   
–ingestion-id “aly-`date +%m%d%y%H%M%S`” --ingestion-type FULL\_REFRESH  
–profile qsingest --region us-east-2

The CLI is called in a shell script that first crawls S3 ORC data to load Athena daily table partitions before calling the create-ingestion CLI to load SPICE. I would like to change this CLI to do an incremental refresh with a lookback of 3 days.

Is this supported by the CLI? What changes would be needed to the CLI above?

Thanks,  
Kevin

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [April 20, 2023, 7:43am UTC](https://community.amazonquick.com/t/how-to-change-spice-refresh-from-full-to-incremental-using-create-ingestion-cli/12481/2 "2023-04-20T07:43:06Z")

</div>

Hi @koxley - Welcome to AWS Quick Sight Community. Can you explore the boto3 API update refresh schedule. Before implementing in the actual data set, do a POC for the same. I have not used this but from documentation, we can update the schedule.  
Please find the document link below.

> **[update\_refresh\_schedule - Boto3 1.40.47 documentation](https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/update_refresh_schedule.html)**

Regards - Sanjeeb