TruePrivacy + Snowflake
Discover PII in Snowflake tables and execute cross-table deletion for DSRs.
Overview
Snowflake is the leading cloud data platform, used to store and analyze data across the entire business — including large volumes of personal data from customer, employee, and user datasets. TruePrivacy connects to Snowflake using a dedicated service account to scan all databases, schemas, and tables for personal data, classifying fields by data category and adding them to your data inventory.
For DSR deletion, TruePrivacy generates and executes parameterized SQL DELETE and UPDATE statements across all relevant Snowflake tables, with full logging of every query executed for the compliance audit trail.
What TruePrivacy can do
Data types accessed
- •Customer records
- •User profiles
- •Email addresses
- •Phone numbers
- •Transaction records
- •Behavioral data
- •Any structured PII across all schemas
DSR capabilities
- Execute targeted DELETE statements across relevant tables
- Anonymise specific fields with UPDATE statements
- Export data subject records as CSV for access requests
- Search across all schemas by email, phone, or custom identifier
How it works
- 1
Create a dedicated Snowflake service account for TruePrivacy with the required database read (and optionally write) privileges.
- 2
TruePrivacy scans all databases, schemas, and tables — analysing column names and sample values to identify personal data fields.
- 3
Discovered personal data fields are classified by category (names, emails, phone numbers, addresses, etc.) and added to your data inventory.
- 4
For DSR deletion, TruePrivacy generates targeted DELETE/UPDATE SQL statements scoped to the data subject's records and executes them under the service account.
Frequently asked questions
For data discovery, TruePrivacy needs USAGE on all relevant databases and schemas, and SELECT on all tables to scan. For DSR automation, it additionally needs DELETE and UPDATE on tables that contain personal data. We strongly recommend creating a dedicated role (e.g. TRUEPRIVACY_ROLE) and a dedicated service account user assigned only that role.
TruePrivacy's deletion queries use parameterized WHERE clauses scoped to the relevant identifier (email, user ID, etc.). For partitioned tables, Snowflake's query optimizer uses partition pruning to minimize the scan scope — making deletion queries efficient even on very large tables.
Yes. During setup you can specify which databases, schemas, or tables TruePrivacy should include or exclude from scanning. This allows you to focus discovery on production data schemas and skip staging, development, or metadata schemas.
Yes. Every SQL query executed by TruePrivacy in Snowflake is logged in TruePrivacy's audit trail, including the query text, the parameters used, and the number of rows affected. This provides a complete record of every deletion action for compliance purposes.
Connect TruePrivacy to Snowflake today
Start your free trial and connect Snowflake in 15 minutes.