Stored procedures¶

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

Copy

Snowflake supports the following stored procedures, grouped by feature:

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
Notifications	SYSTEM$SEND_SNOWFLAKE_NOTIFICATION SYSTEM$SEND_EMAIL
Semantic views	SYSTEM$CREATE_SEMANTIC_VIEW_FROM_YAML
Synthetic data	GENERATE_SYNTHETIC_DATA