DYNAMIC_TABLE_REFRESH_HISTORY function: DATA_TIMESTAMP value in output displayed in new format¶
This behavior change is in the 2023_06 bundle.
For the current status of the bundle, refer to Bundle History.
After manually refreshing a dynamic table using the ALTER DYNAMIC TABLE … REFRESH command, when you call the DYNAMIC_TABLE_REFRESH_HISTORY function (in INFORMATION_SCHEMA), the DATA_TIMESTAMP returned result behaves as follows:
DATA_TIMESTAMP is shown as a raw value (seconds since epoch). Documentation lists the column data type incorrectly as TIMESTAMP_LTZ.
DATA_TIMESTAMP will be shown as a human readable timestamp.