Full refresh is limited to daily refresh

[Giridhar.Prabhu]

Hi @tructran

I had run into this issue before. The root cause was the underlying dataset.

In my case I had the following:
a. Dataset 1 based on Custom SQL
b. Dataset 2 based on Custom SQL ( Table 1) and Dataset 1 (Table 2)

When this is the case where you have join with another dataset bincremental refreshes are not allowed. You end up with a full daily refresh.

Refer this thread

SPICE dataset - Ingestion filter / Incremental referesh

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: [image] 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 t…