I have a SPICE dataset that uses Custom SQL. Our application knows when data has been changed that affects the SPICE dataset. This data changes infrequently, but then it changes we want the dataset to be updated immediately. I looked in the API, but did not find any way to tell a SPICE dataset to refresh. Did I miss something?
The only to schedule the incremental refresh. you can configure it on 15 minutes.
There is not triggered based refresh available yet.
You can use the create-ingestion API/CLI call to trigger a SPICE data set to be refreshed. You will need to tie this to your data pipeline refresh and trigger it at the end.