hash_sha1()

Applies to: ✅ Azure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns a sha1 hash value of the source input.

Syntax

hash_sha1(source)

Learn more about syntax conventions.

Parameters

Name Type Required Description
source scalar ✔️ The value to be hashed.

Returns

The sha1 hash value of the given scalar, encoded as a hex string (a string of characters, each two of which represent a single Hex number between 0 and 255).

Warning

The algorithm used by this function (SHA1) is guaranteed to not be modified in the future, but is very complex to calculate. If you need a "lightweight" hash function for the duration of a single query, consider using hash().

Examples

print 
    h1=hash_sha1("World"),
    h2=hash_sha1(datetime(2020-01-01))

Output

h1 h2
70c07ec18ef89c5309bbb0937f3a6342411e1fdd e903e533f4d636b4fc0dcf3cf81e7b7f330de776

The following example uses the hash_sha1() function to aggregate StormEvents based on State's SHA1 hash value.

StormEvents 
| summarize StormCount = count() by State, StateHash=hash_sha1(State)
| top 5 by StormCount desc

Output

State StateHash StormCount
TEXAS 3128d805194d4e6141766cc846778eeacb12e3ea 4701
KANSAS ea926e17098148921e472b1a760cd5a8117e84d6 3166
IOWA cacf86ec119cfd5b574bde5b59604774de3273db 2337
ILLINOIS 03740763b16dae9d799097f51623fe635d8c4852 2022
MISSOURI 26d938907240121b54d9e039473dacc96e712f61 2016