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.

Ref: 1231