Hash Key

Perform MD5 / SHA256 hashing algorithm on a source key to a new destination key

Hashing your data can be useful if you need to validate the authenticity and integrity of your data. The Hash Key action hashes the value of a key in every record. When applied to your pipeline, the Hash Key action hashes the value of every occurrence of a specific key and return the hashed algorithm value and a new key name. The Hash Key action provides the MD5 and SHA256 functions for hashing your keys.

For example, given the following sample website log data:

{"timestamp":"2023-03-28T09:08:41.64283645Z","user_id":3,"page_id":30,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:42.643343109Z","user_id":4,"page_id":10,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:48.643600498Z","user_id":1,"page_id":50,"action":"click"}
{"timestamp":"2023-03-28T09:08:50.643773688Z","user_id":5,"page_id":40,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:51.643932272Z","user_id":1,"page_id":30,"action":"purchase"}
{"timestamp":"2023-03-28T09:08:56.644080944Z","user_id":2,"page_id":40,"action":"click"}
{"timestamp":"2023-03-28T09:09:03.64425954Z","user_id":3,"page_id":30,"action":"click"}
{"timestamp":"2023-03-28T09:09:03.644317046Z","user_id":1,"page_id":20,"action":"view"}
{"timestamp":"2023-03-28T09:09:10.64447719Z","user_id":2,"page_id":50,"action":"purchase"}
{"timestamp":"2023-03-28T09:09:17.644810963Z","user_id":2,"page_id":10,"action":"view"}
{"timestamp":"2023-03-28T09:09:20.644994805Z","user_id":1,"page_id":50,"action":"view"}

To hash the value of every occurrence of user_id:

1. In the processing rules tab, in the Actions dropdown, select Allow keys.

2. In the Source key field, enter user_id.

3. In the Destination key field, enter customer_id.

4. Use the dropdowns to select the hashing algorithm to use and the scheme of your output.

5. Click Apply.

Your processing rule will now hash the value of every occurrence of the user_id key and return it as customer_id and the hashed value.