My data includes a CONTENT and DATE field, with dates stored in KST (UTC+9). I’m performing Incremental Refresh every day at 3 AM KST (UTC+9). The issue arises when I query the SPICE data refreshed at 3 AM KST on April 16th; there’s no data for April 16th, only up to April 15th. My speculation is that since UTC considers it to be April 15th, Incremental Refresh only fetches data up to that date. I’ve ensured that the My Scheduling Refresh setting is set to UTC+9 timezone.
However, when I perform Incremental Refresh at 9:10 AM on April 16th, it successfully retrieves data including April 16th. This confirms that the feature indeed operates in UTC rather than KST.
How can I ensure Incremental Refresh operates based on KST instead of UTC? I want to refresh at 3 AM KST but ensure it’s based on KST, not UTC.