Account Usage views: Add support for versioned schemas in Snowflake Native Apps

Attention

This behavior change is in the 2024_01 bundle.

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

This behavior change alters the output of Account Usage views to include information about versioned schemas.

Before the change:

The Account Usage views may not display information about versioned schemas.

After the change:

The Account Usage views contain information about versioned schemas as described.

Changes to the SCHEMATA view

This behavior change adds the following columns to the SCHEMATA view:

  • SCHEMA_TYPE indicates the type of schema. Possible values are:

    • VERSIONED

    • STANDARD

  • VERSION_NAME indicates the name of the schema if it is a versioned schema, or NULL otherwise.

  • VERSIONED_SCHEMA_ID indicates the internal/system-generated identifier of the schema if it is a versioned schema or NULL otherwise.

This behavior change modifies the following columns in the Account Usage:

  • SCHEMA_NAME

  • CATALOG_NAME

  • CATALOG_ID

Changes to other Account Usage views

This behavior change modifies the following views to include additional rows if the schema is a versioned schema:

  • ALERT_HISTORY

  • AUTOMATIC_CLUSTERING_HISTORY

  • CLASS_INSTANCES

  • CLASSES

  • COPY_HISTORY

  • FILE_FORMATS

  • LOAD_HISTORY

  • MASKING_POLICIES

  • MATERIALIZED_VIEW_REFRESH_HISTORY

  • PIPES

  • PROCEDURES

  • REFERENTIAL_CONSTRAINTS

  • ROLES

  • ROW_ACCESS_POLICIES

  • SEARCH_OPTIMIZATION_HISTORY

  • SEQUENCES

  • SERVERLESS_TASK_HISTORY

  • SESSION_POLICIES

  • STAGES

  • TABLE_CONSTRAINTS

  • TAGS

  • VIEWS

The ALERT_HISTORY view also contains the following new columns:

  • DATABASE_ID

  • SCHEMA_ID

The PROCEDURES view also contains the following new columns:

  • PROCEDURE_SCHEMA_ID

  • PROCEDURE_CATALOG_ID

Ref: 1463