Security
Hash
Adds a fingerprint of each row — or of each picked column — made with MD5, SHA-1, SHA-256 or SHA-512, so two tables can be compared row by row without moving the data itself.
When to use it
Use it to reconcile a source and a target (same hash, same row), to spot changed records between loads, or to share a stable key without revealing the values behind it.
In a pipeline
File InputHashJoin TablesExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Columns | select | — | None picked: every column |
| Hash | select | — | combined |
| Algorithm | select | — | sha256 |
| Output column | text | — | Row Hash |
Example
A row hash for reconciliation
- Columns=Id, Amount
- Algorithm=MD5
| Id | Amount |
|---|---|
| P-1 | 120.00 |
| P-2 | 80.50 |
| Id | Amount | Row Hash |
|---|---|---|
| P-1 | 120.00 | 853190c92e0ead297bac2a136d18e867 |
| P-2 | 80.50 | c0bfeb7179f26e5c13f3dc21b19fc440 |
Worth knowing
- With no columns picked, every column is hashed together; pick the columns that define "the same row" to ignore load dates and the like.
- Values are joined with an invisible separator before hashing, so "ab"+"c" and "a"+"bc" give different hashes.
- Each column on its own adds "<column> Hash" after every picked column; blank cells stay blank.
- MD5 and SHA-1 are fine for change detection but not for security; use SHA-256 when the hash must not be guessable.