Hi @andres007
Thanks for the prompt response.
Unfortunately I do not see that option when I try and select a refresh schedule - this is what I see below:
I do have a date field and this is set as a “Date” in the data type within the dataset.
Just to note - I do have enterpise and in the Frequency drop down, I do see “hourly” (as suggesting in the link provided).
Further info - the main table I have in SPICE would typically be referred to a fact table and I have created a join in the Data Prep screen on a dimension table (this contains static data). The ‘Query Mode’ in the bottom left of the screen is ‘SPICE’. When selecting ‘Add Data’ in the data prep screen, I see the below listed next to my table:
Could this have something to do with the incremental refresh?
For testing, I added a small Custom SQL data source with a date field and no join (as the join is done in the SQL query itself) - and now when I try and set up a schedule for this dataset, it gives me the option to implement incremental refresh.
What am i missing?
Thanks.