BACKUP_OPERATION_HISTORY views: TIMESTAMP_LTZ always used for the start_time column (Preview)¶
Attention
This behavior change is in the 2026_01 bundle.
For the current status of the bundle, refer to Bundle history.
In the ACCOUNT_USAGE.BACKUP_OPERATION_HISTORY and ORGANIZATION_USAGE.BACKUP_OPERATION_HISTORY views, the start_time column behaves as follows:
- Before the change:
The
start_timecolumn has the type TIMESTAMP_LTZ or another type returned by the TO_TIMESTAMP function, depending on the value of the TIMESTAMP_TYPE_MAPPING parameter.- After the change:
The
start_timecolumn will have the type TIMESTAMP_LTZ, regardless of the setting of the TIMESTAMP_TYPE_MAPPING parameter.
This change is being made to ensure consistent behavior across these views and to align with standard Snowflake practices for TIMESTAMP columns in system views.
The start_time column in the following deprecated views will also have this change:
Ref: 2200