CLASSES View¶

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

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.

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

Retrieve all classes in the SNOWFLAKE database:

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

Copy