CLASSES view

This Information Schema view displays a row for each class in the database.

See also:

CLASSES view, CLASS_INSTANCES view

Columns

Column Name

Data Type

Description

NAME

VARCHAR

Name of the instance.

SCHEMA_NAME

VARCHAR

Name of the schema the instance belongs to.

DATABASE_NAME

VARCHAR

Name of the database the instance belongs to.

VERSION

VARCHAR

Version of the class that is currently active in this account.

OWNER

VARCHAR

Name of the role that owns the instance.

OWNER_ROLE_TYPE

VARCHAR

The internal/system-generated identifier of the role that owns the instance of the class.

IS_SERVICE_CLASS

VARCHAR

TRUE if the class is a SERVICE class.

CREATED

TIMESTAMP_LTZ

Date and time when the instance was created.

COMMENT

VARCHAR

Comment for the instance.

Usage notes

The view only displays objects for which the current role for the session has been granted access privileges.

Examples

Retrieve all classes in the SNOWFLAKE database:

SELECT name, schema_name, database_name, version
    FROM SNOWFLAKE.INFORMATION_SCHEMA.CLASSES;
Copy