Snowflake Database¶
Snowflake provides a system-defined, read-only shared database named SNOWFLAKE that contains metadata, as well as 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 utilized in select Snowflake features. Currently, the schema only contains the system tags used by data classification. Additional views and schema objects will be introduced in future releases.
- 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.
- 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.
Preview Feature — Open
The ML schema is being made available in all accounts in preparation for upcoming machine learning features.
- ML
Will contain machine learning functions built by Snowflake as they are released.
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 will remain inaccessible unless access is explicitly granted by ACCOUNTADMIN, including ACCOUNT_USAGE, READER_ACCOUNT_USAGE, ORGANIZATION_USAGE, and DATA_SHARING_USAGE.
Privileges to perform other actions on these views can be granted to other roles in your account. For more details, refer to Enabling Snowflake Database Usage for Other Roles.
Next Topics: