SNOWFLAKE 数据库¶

Snowflake 提供了一个名为 SNOWFLAKE 的系统定义的只读共享数据库，其中包含有关组织和账户中对象的元数据和历史使用情况数据。SNOWFLAKE 数据库是 Secure Data Sharing 的一个示例，为组织和账户提供对象元数据和其他使用情况指标。

在每个账户中，SNOWFLAKE 数据库包含以下架构（也是只读的）：

ACCOUNT_USAGE:

显示账户的对象元数据和使用情况指标的视图。

ALERT:

用于 :doc:`警报对象 </user-guide/alerts>`的函数。

BILLING:

包含 Snowflake 经销商和分销商客户的账单信息的视图。只有经销商和分销商才能访问 BILLING 架构中的视图。

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:

包含与数据隐私相关的函数和存储过程。还包含 custom_classifier 类。

DATA_SHARING_USAGE:

显示与 Snowflake Marketplace 或数据交换中发布的列表相关的对象元数据和使用情况指标的视图。

EXTERNAL_ACCESS:

Schema that contains built-in network rules specific to connections for network traffic outbound from Snowflake. For information about egress network rules, see Snowflake-managed egress network rules.

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:

This schema is used by some account-level Snowflake features for logging to telemetry event tables. For more information about this schema, see LOCAL.

ML:

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

MONITORING:

提供您账户中对象的历史信息的视图。在 Information Schema 中，返回历史信息的视图和表函数未来将最终迁移到 MONITORING 架构。

NETWORK_SECURITY:

Schema that contains built-in network rules that define the set of allowed IP addresses that a frequently used, third-party partner application uses to connect with Snowflake. For more information about Snowflake-managed network rules, see Snowflake-managed network rules.

NOTIFICATION:

发送通知 的存储过程和函数。

ORGANIZATION_USAGE:

显示组织中所有账户的历史使用情况数据的视图。

READER_ACCOUNT_USAGE:

与 ACCOUNT_USAGE 类似，但仅包含与为该账户预置的阅读者账户（如果有）相关的视图。

SPCS:

与 Snowpark Container Services 一起使用的函数。

TELEMETRY:

支持 收集遥测数据 的表、视图和存储过程，例如日志消息、跟踪事件数据和指标数据。

TRUST_CENTER:

Views that display data about the Trust Center extensions.

某些 SNOWFLAKE 架构包括类。类是一种可扩展的对象类型，用于封装对象数据和代码。有关更多信息，请参阅 Snowflake 类。