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. Organization users and organization user groups
                7. Regular expressions
                8. Semi-structured and structured data
                9. String & binary
                10. System
                11. Table
                12. Vector
                13. Window
                14. 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