Data Lineage for Personal Data: Show a Column Was Masked
Before you share a file, you may need to show what was done to the personal data in it. Lineage gives you that record.
Short answer: when you mask a file in Data Utility, the step is recorded with the columns it handled and the settings used. Data Lineage then lets you follow a column such as email through every step, and download a report that shows the chain. It supports your own records. It is not legal advice and does not by itself make a file compliant.
Why record what happened to personal data
Teams are often asked later: was the phone number removed, was the name hashed, which version went to the vendor? Without a record the honest answer is "I think so". A lineage turns that into something you can show.
What the lineage shows
- The input file and where it came from.
- Each masking step and its settings, for example which columns were masked and how.
- The output file and its row count.
- Which columns were kept, changed, added or dropped at every step.
The personal data check
On the latest file, Data Lineage lists columns whose names look personal, such as email, phone or name, and shows whether a masking step handled them. This is a guess from column names only. Values are never read, and a column with an unusual name may be missed. Treat it as a prompt to check, not a guarantee.
How to document a masking step
- Open Data Masking and choose the columns and the method for each.
- Download the result or save it.
- Open Data Lineage, select the lineage and click the masking step to see what was done.
- Follow a column to confirm it was masked before any later step.
- Download Result + lineage to keep the report next to the file you share.
Limits to keep in mind
- Only work done in Data Utility is recorded.
- Lineage records what was done. It does not tell you whether the masking is strong enough for your rules.
- History is stored in your browser. Download the report to keep it.
- No user accounts: it does not record who did the step.
Related tool pages
- Data Lineage Version History: Keep a version history of your data lineage and compare any two versions: steps, settings, columns and row counts. Export a report. Free and private.
- Free Data Lineage Tool: A free data lineage tool for files: transform data, see input, transformations and result as a graph, and download a shareable HTML report. No signup.
- Data Lineage Report as HTML: Download a data lineage report as one HTML page: a tree from the input file through every transformation to the result, with a SHA-256 checksum.
- Share Your Data Together with Its Lineage: Send a result file and the proof of how it was made in one ZIP: your data, an HTML lineage report and a JSON copy. Free, made in your browser.
- Data Audit Trail for CSV and Excel Files: Keep an audit trail of what was done to a CSV or Excel file: conversions, cleaning, joins and masking, with the settings used. Free, in your browser.
- Data Provenance Tool for Files: Record where a data file came from and every transformation applied to it. See it as a graph and export an HTML provenance report. Free, no upload.
Also try
How to use the Data Lineage: step by step
- Mask the file in Data Masking and save the result.
- Open Data Lineage and select the lineage.
- Follow a personal data column through the steps.
- Download Result + lineage.
When to use the Data Lineage
- Show which columns were masked before sharing
- Keep a record of anonymization for a review
- Check that a later step did not add personal data back
- Send a vendor a file with its masking history
Example
Input: customers.csv → Data Masking → Format Converter
Output: customers.json + LINEAGE.html (input → transformations → result)
Frequently asked questions
Does data lineage make my file GDPR compliant?
No. It gives you a record of what was done to the file. Whether that meets your obligations is for you and your advisers to judge.
Does it read the values in my file?
The personal data check looks at column names only, never at the values.
Is my data uploaded?
No. Everything runs in your browser.
Can I show a reviewer the steps?
Yes. Download Result + lineage for an HTML report, or save the graph as an image.
Tip: Check the personal data list yourself. It is based on column names only.