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
                                                                        1. JSON and XML parsing
                                                                        2. CHECK_JSON
                                                                          • CHECK_XML
                                                                            • JSON_EXTRACT_PATH_TEXT
                                                                              • PARSE_JSON
                                                                                • TRY_PARSE_JSON
                                                                                  • PARSE_XML
                                                                                    • STRIP_NULL_VALUE
                                                                                      • Array/object creation and manipulation
                                                                                      • ARRAY_AGG
                                                                                        • ARRAY_APPEND
                                                                                          • ARRAY_CAT
                                                                                            • ARRAY_COMPACT
                                                                                              • ARRAY_CONSTRUCT
                                                                                                • ARRAY_CONSTRUCT_COMPACT
                                                                                                  • ARRAY_CONTAINS
                                                                                                    • ARRAY_DISTINCT
                                                                                                      • ARRAY_EXCEPT
                                                                                                        • ARRAY_FLATTEN