DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • AISQL
              1. Scalar functions
                1. AI_CLASSIFY
                  • AI_COMPLETE
                  • AI_COUNT_TOKENS
                    • AI_EMBED
                      • AI_EXTRACT
                        • AI_FILTER
                          • AI_PARSE_DOCUMENT
                            • AI_SENTIMENT
                              • AI_SIMILARITY
                                • AI_TRANSCRIBE
                                  • AI_TRANSLATE
                                    • CLASSIFY_TEXT (SNOWFLAKE.CORTEX)
                                      • COMPLETE (SNOWFLAKE.CORTEX)
                                        • COMPLETE multimodal (images) (SNOWFLAKE.CORTEX)
                                          • EMBED_TEXT_768 (SNOWFLAKE.CORTEX)
                                            • EMBED_TEXT_1024 (SNOWFLAKE.CORTEX)
                                              • ENTITY_SENTIMENT (SNOWFLAKE.CORTEX)
                                                • EXTRACT_ANSWER (SNOWFLAKE.CORTEX)
                                                  • FINETUNE (SNOWFLAKE.CORTEX)
                                                  • PARSE_DOCUMENT (SNOWFLAKE.CORTEX)
                                                    • SENTIMENT (SNOWFLAKE.CORTEX)
                                                      • SUMMARIZE (SNOWFLAKE.CORTEX)
                                                        • TRANSLATE (SNOWFLAKE.CORTEX)
                                                        • Aggregate functions
                                                          1. AI_AGG
                                                            • AI_SUMMARIZE_AGG
                                                            • Helper functions
                                                              1. COUNT_TOKENS (SNOWFLAKE.CORTEX)
                                                                • SEARCH_PREVIEW (SNOWFLAKE.CORTEX)
                                                                  • SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX)
                                                                    • SPLIT_TEXT_RECURSIVE_CHARACTER (SNOWFLAKE.CORTEX)
                                                                      • TRY_COMPLETE (SNOWFLAKE.CORTEX)
                                                                    • Bitwise expression
                                                                    • Conditional expression
                                                                    • Context
                                                                    • Conversion
                                                                    • Data generation
                                                                    • Data metric
                                                                    • Date & time
                                                                    • Differential privacy
                                                                    • Encryption
                                                                    • File
                                                                    • Geospatial
                                                                    • Hash
                                                                    • Metadata
                                                                    • ML Model Monitors
                                                                    • Notification
                                                                    • Numeric
                                                                    • Organization users and organization user groups
                                                                    • Regular expressions
                                                                    • Semi-structured and structured data
                                                                    • Snowpark Container Services
                                                                    • String & binary
                                                                    • System
                                                                    • Table
                                                                    • Vector
                                                                    • Window
                                                                    • Stored procedures
                                                                        1. Cortex Powered Object Descriptions
                                                                        2. 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
                                                                                          • Class reference
                                                                                          • Scripting reference
                                                                                          • General reference
                                                                                          • API reference
                                                                                            ReferenceFunction and stored procedure referenceStored procedures

                                                                                            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

                                                                                            Was this page helpful?

                                                                                            Visit Snowflake
                                                                                            Join the conversation
                                                                                            Develop with Snowflake
                                                                                            Share your feedback
                                                                                            Read the latest on our blog
                                                                                            Get your own certification
                                                                                            Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                            Language: English
                                                                                            • English
                                                                                            • Français
                                                                                            • Deutsch
                                                                                            • 日本語
                                                                                            • 한국어
                                                                                            • Português