VIEWS View (Information Schema): New Columns in View

Attention

This behavior change is in the 2023_04 bundle.

For the current status of the bundle, refer to Bundle History.

Snowflake has added two columns, LAST_DDL and LAST_DDL_BY, to the VIEWS view in the INFORMATION_SCHEMA schema. These columns record the timestamp of the last DDL operation performed on each view and the username of the user who performed it.

Column NameData TypeDescription
LAST_DDLTIMESTAMP_LTZTimestamp of the last DDL operation performed on the table or view, including database refreshes for replication (if the refresh changes visible properties for the table/view).
LAST_DDL_BYTEXTUsername of the user who performed the last DDL operation on the table or view.

Ref: 1127