SNOWFLAKE database

Snowflake provides a system-defined, read-only shared database named SNOWFLAKE that contains metadata and historical usage data about the objects in your organization and accounts. The SNOWFLAKE database is an example of Secure Data Sharing, and provides object metadata and other usage metrics for your organization and accounts.

In each account, the SNOWFLAKE database contains the following schemas (also read-only):

ACCOUNT_USAGE:

Views that display object metadata and usage metrics for your account.

ALERT:

Functions that are intended for use in alert objects.

CORE:

Contains views and other schema objects to support select Snowflake features, such as the system tags used with classifying data and the system data metric functions used to measure data quality.

DATA_PRIVACY:

Contains functions and stored procedures related to data privacy. Also contains the custom_classifier class.

DATA_SHARING_USAGE:

Views that display object metadata and usage metrics related to listings published in the Snowflake Marketplace or a data exchange.

INFORMATION_SCHEMA:

This schema is automatically created in all databases. In a shared database such as SNOWFLAKE, this schema doesn’t serve a purpose and can be disregarded.

LOCAL:

Currently, this schema only contains one view, DATA_QUALITY_MONITORING_RESULTS.

You can query the view or call the DATA_QUALITY_MONITORING_RESULTS table function to obtain data metric function results.

ML:

Contains ML functions (a suite of analysis tools built by Snowflake), and the DOCUMENT_INTELLIGENCE class used in Document AI.

MONITORING:

Views that provide historical information for objects in your account. In the Information Schema, the views and table functions that return historical information will eventually be migrated to the MONITORING schema in the future.

NOTIFICATION:

Stored procedures and functions for sending notifications.

ORGANIZATION_USAGE:

Views that display historical usage data across all the accounts in your organization.

READER_ACCOUNT_USAGE:

Similar to ACCOUNT_USAGE, but only contains views relevant to the reader accounts (if any) provisioned for the account.

TELEMETRY:

Tables, views, and stored procedures to support collecting telemetry data such as log messages, trace event data, and metrics data.

Some SNOWFLAKE schemas include classes. A class is an extensible object type that encapsulates object data and code. For more information, see Snowflake classes.

Important

By default, the SNOWFLAKE database is visible to all users. This does not mean all objects within the SNOWFLAKE database are accessible to all users.

Objects that are not meant to be accessible by default remain inaccessible unless access is explicitly granted by a user with the ACCOUNTADMIN role, including access to the ACCOUNT_USAGE, READER_ACCOUNT_USAGE, ORGANIZATION_USAGE, and DATA_SHARING_USAGE schemas.

Privileges to perform other actions on these views can be granted to other roles in your account. For more information, see Enabling other roles to use schemas in the SNOWFLAKE database.

Next Topics:

Language: English