Columns¶

Organization-level columns

Additional columns

Usage notes¶

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

• The view displays all of the databases in an account.

• 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.