Canner
Data policies
Project duration: 2023/08~2023/10
CONTEXT
Our banking and manufacturing clients must follow data policies to protect personal information. Canner's product only allowed users to mask data by writing SQL, which is time-consuming and makes it hard to audit which table uses which policy if the company's compliance team needs to review it.
CORE Problems
01
Manual effort in writing SQL code for masking sensitive data
“
Masking data can be time-consuming and involves many repetitive processes. For example, I need to mask customer identity card information in 10 tables, I have to write 10 separate SQL statements to finish this task.
-Client A,C,D
DeliverableS
Design Solution: Build data policy once, apply for any data
I designed a flexible data policy builder that allows users to define masking rules once and apply them to any relevant data. This approach ensures consistency, efficiency, and scalability in data protection.
Key features of the solution:
Categorized Use Cases – Users can select predefined masking rules based on common data types (e.g., addresses, dates of birth).
Built-in Masking Patterns – The system provides commonly used patterns, reducing manual effort and ensuring compliance with data privacy standards.
Example Preview – Users can see the output before applying, improving clarity and reducing errors.
When you finish creating the policy, simply select the table and column to apply it to.
In each data source, you can track the tables and columns to which each data policy applies.
impacts
Reduce the manual effort required to write SQL code.
By implementing the data policy builder, our customers reduced the time required for SQL-based data masking from 3–5 days to just 1–2 days.
Helped the company sign a major client from a leading banking company.
By streamlining data policy and compliance through a flexible data policy builder, we enhanced the platform’s appeal to enterprise clients. This improvement played a key role in securing a major contract with a leading banking company.
View other projects