Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The RefreshPolicy object represents the policy used for refreshing a table’s data. It is a child of a Table object and requires compatibility level 1450 or higher.<94>
The RefreshPolicy object has the following properties.
|
Name |
Type |
Description |
|---|---|---|
|
ID |
unsignedLong |
A reference to the object.
|
|
TableID |
unsignedLong |
An ID-based reference to a Table object. |
|
PolicyType |
enumeration |
A value that specifies the type of the refresh policy. The possible values are as follows:
|
|
RollingWindowGranularity |
enumeration |
A value that indicates the granularity of the rolling window for the whole data set. The possible values are as follows:
|
|
RollingWindowPeriods |
int |
The number of periods for the rolling window for the whole data set. |
|
IncrementalGranularity |
enumeration |
A value that indicates the granularity of the most recent incremental refresh range. The possible values are as follows:
|
|
IncrementalPeriods |
int |
The number of periods for the incremental refresh range. |
|
IncrementalPeriodsOffset |
int |
The lag or leading periods from Now() to the rolling window head. |
|
PollingExpression |
string |
The M expression that is evaluated and stored for each partition upon each refresh or merge operation. |
|
SourceExpression |
string |
The M expression that is used as the source M expression for new partitions. It includes the date filter by referring to two M parameters named [RangeStart] and [RangeEnd]. |
|
Mode |
enumeration |
A value that defines the mode of the refresh policy applied during incremental refresh. The possible values are as follows:
Compatibility level 1565 or higher is required. |