Snowflake Database

Snowflake provides a system-defined, read-only shared database named SNOWFLAKE that contains metatdata, as well as historical usage data, about the objects in your organization and accounts.

When an account is provisioned, Snowflake automatically imports the SNOWFLAKE database into the account from a share named ACCOUNT_USAGE. The database is an example of Snowflake utilizing Secure Data Sharing to provide 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.

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.

Important

By default, only account administrators (users with the ACCOUNTADMIN role) can access the SNOWFLAKE database and schemas, or perform queries on the views; however, privileges on the database can be granted to other roles in your account to allow other users to access the objects. For more details, see Enabling Snowflake Database Usage for Other Roles.

Next Topics:

Back to top