存储过程

Snowflake provides stored procedures to facilitate using certain Snowflake features. To find the stored procedures that are associated with a particular Snowflake Class, see SQL class reference.

Use CALL to call a stored procedure. For example:

CALL SYSTEM$CLASSIFY('hr.tables.empl_info', null);

Snowflake 支持以下按功能分组的存储过程：

Feature	Stored procedure
Cortex Powered Object Descriptions	- AI_GENERATE_TABLE_DESC
Data classification	ASSOCIATE_SEMANTIC_CATEGORY_TAGS SYSTEM$CLASSIFY SYSTEM$CLASSIFY_SCHEMA SYSTEM$CANCEL_CLASSIFY_SCHEMA
Data sharing and collaboration	- SYSTEM$REQUEST_LISTING_AND_WAIT
Default event table	ADD_ROW_ACCESS_POLICY_ON_EVENTS_VIEW DROP_ROW_ACCESS_POLICY_ON_EVENTS_VIEW
Differential privacy	- RESET_PRIVACY_BUDGET
Network security	EVALUATE_CANDIDATE_NETWORK_POLICY RECOMMEND_NETWORK_POLICY
Notifications	SYSTEM$SEND_SNOWFLAKE_NOTIFICATION SYSTEM$SEND_EMAIL
Semantic views	- SYSTEM$CREATE_SEMANTIC_VIEW_FROM_YAML
Synthetic data	- GENERATE_SYNTHETIC_DATA
Trust Center	REGISTER_EXTENSION DEREGISTER_EXTENSION