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.

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):


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


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.


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


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.


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


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


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