DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • Bitwise expression
            • Conditional expression
            • Context
            • Conversion
            • Data generation
            • Data metric
            • Date & time
            • Differential privacy
            • Encryption
            • File
            • Geospatial
            • Hash
                1. HASH
                  • HASH_AGG
                2. Metadata
                3. ML Model Monitors
                4. Notification
                5. Numeric
                6. Regular expressions
                7. Semi-structured and structured data
                8. String & binary
                9. System
                10. Table
                11. Vector
                12. Window
                13. Stored procedures
            • Class reference
            • Scripting reference
            • General reference
            • API reference
              ReferenceFunction and stored procedure referenceHash

              Hash functionsΒΆ

              Snowflake provides hash functions, which take input value(s) and return a signed 64-bit numeric value. Hash functions are deterministic. Snowflake provides both a scalar hash function and an aggregate hash function, both of which are listed here.

              Note

              The hash functions are not cryptographic hash functions.

              For cryptographic functions, use the SHA families of functions (see String & binary functions).

              Function Name

              Notes

              HASH

              HASH_AGG

              Aggregate function.

              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 TermsΒ© 2025 Snowflake, Inc. All Rights Reserved.
              Language: English
              • English
              • FranΓ§ais
              • Deutsch
              • ζ—₯本θͺž
              • ν•œκ΅­μ–΄
              • PortuguΓͺs