TruePrivacy + Amazon Redshift
Discover and classify personal data across Redshift schemas.
Overview
Amazon Redshift is AWS's managed data warehouse service used for large-scale analytics. TruePrivacy connects to Redshift via a dedicated database user to scan schemas and tables for personal data, classify the data by category, and execute deletion operations for DSR compliance.
The integration is particularly important for AWS-native organizations that store customer and user data in Redshift for business intelligence and analytics, ensuring that these data stores are included in the compliance programme.
What TruePrivacy can do
Data types accessed
- •Customer records
- •User profiles
- •Transaction data
- •Event tables
- •Any structured PII in analytics schemas
DSR capabilities
- Execute DELETE statements across Redshift schemas
- Export data subject records for access requests
- Classify personal data fields by category
How it works
- 1
Create a dedicated Redshift database user for TruePrivacy with SELECT privileges and optionally DELETE/UPDATE privileges.
- 2
TruePrivacy connects to Redshift and scans all schemas and tables, identifying personal data fields through column analysis.
- 3
Discovered personal data is classified and mapped to your data inventory.
- 4
DSR deletion triggers parameterized DELETE SQL statements across relevant Redshift tables.
Frequently asked questions
TruePrivacy needs a Redshift database user with USAGE on the relevant schemas, SELECT on all tables for discovery, and DELETE/UPDATE on tables containing personal data for DSR automation.
TruePrivacy connects to Redshift using SSL/TLS encryption. We recommend configuring your Redshift security group to allow inbound connections only from TruePrivacy's published IP ranges, and enabling Redshift audit logging to track all queries.
Connect TruePrivacy to Amazon Redshift today
Start your free trial and connect Amazon Redshift in 15 minutes.