Columns¶

Organization-level columns

Additional columns

Usage notes¶

• Latency for the view may be up to 24 hours.

• The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.

• The LAST_ALTERED column is updated when the following operations are performed on an object:

  • DDL operations.

  • DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.

  • Background maintenance operations on metadata performed by Snowflake.

  For views and tables, use the LAST_DDL column for the last modification time for an object.

• The value in the LAST_DDL column is updated as follows:

  • When a table or view is created, the LAST_DDL timestamp is the same as the CREATED timestamp.

  • When a table or view is dropped, the LAST_DDL timestamp is the same as the DELETED timestamp.

  • Last DDL data is not available for operations that occurred before the columns were added. The new DDL fields contain null until a DDL operation is executed.

  • For replicated databases, the LAST_DDL and LAST_DDL_BY fields are only updated for objects in the primary database. After failover, the LAST_DDL and LAST_DDL_BY fields are updated for DDL operations for the tables and views in the newly promoted primary database. These fields will remain unchanged for objects in the now secondary database.

  • For objects in secondary databases that are newly created during a refresh operation, these fields are null.