DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
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_EMBED
                    • AI_EXTRACT
                      • AI_FILTER
                        • AI_PARSE_DOCUMENT
                          • AI_SENTIMENT
                            • AI_SIMILARITY
                              • AI_TRANSCRIBE
                                • 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
                                                                    1. Accuracy
                                                                    2. BLANK_COUNT
                                                                      • BLANK_PERCENT
                                                                        • NULL_COUNT
                                                                          • NULL_PERCENT
                                                                            • Freshness
                                                                            • DATA_METRIC_SCHEDULED_TIME
                                                                              • FRESHNESS
                                                                                • Statistics
                                                                                • AVG
                                                                                  • MIN
                                                                                    • MAX
                                                                                      • STDDEV
                                                                                        • Uniqueness
                                                                                        • ACCEPTED_VALUES
                                                                                          • DUPLICATE_COUNT
                                                                                            • UNIQUE_COUNT
                                                                                              • Volume
                                                                                              • ROW_COUNT
                                                                                            • 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
                                                                                        • Class reference
                                                                                        • Scripting reference
                                                                                        • General reference
                                                                                        • API reference
                                                                                          ReferenceFunction and stored procedure referenceData metric

                                                                                          Data metric functions¶

                                                                                          Snowflake provides built-in system data metric functions to measure data quality for tables and views:

                                                                                          • ACCEPTED_VALUES (system data metric function)

                                                                                          • AVG (system data metric function)

                                                                                          • BLANK_COUNT (system data metric function)

                                                                                          • BLANK_PERCENT (system data metric function)

                                                                                          • DATA_METRIC_SCHEDULED_TIME (system data metric function)

                                                                                          • DUPLICATE_COUNT (system data metric function)

                                                                                          • FRESHNESS (system data metric function)

                                                                                          • MAX (system data metric function)

                                                                                          • MIN (system data metric function)

                                                                                          • NULL_COUNT (system data metric function)

                                                                                          • NULL_PERCENT (system data metric function)

                                                                                          • ROW_COUNT (system data metric function)

                                                                                          • STDDEV (system data metric function)

                                                                                          • UNIQUE_COUNT (system data metric function)

                                                                                          For details, see System data metric functions.

                                                                                          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