TruePrivacy + ClickHouse
Discover and delete personal data in ClickHouse analytics database.
Overview
ClickHouse is a high-performance columnar analytics database used for real-time analytics and event data at scale. TruePrivacy integrates with ClickHouse to discover personal data across tables and execute deletion operations — navigating ClickHouse's unique deletion semantics (ALTER TABLE DELETE) to ensure compliance with DSR requests.
For organizations using ClickHouse for product analytics, event logging, or business intelligence, TruePrivacy ensures that personal data in this high-volume store is properly governed and that deletion requests are fulfilled systematically.
What TruePrivacy can do
Data types accessed
- •Event log records
- •User profile data
- •Analytics tables with PII
- •Session and behavioral data
DSR capabilities
- Execute ALTER TABLE DELETE mutations for DSR erasure
- Export data subject records for access requests
- Classify personal data fields across tables
How it works
- 1
Create a dedicated ClickHouse user for TruePrivacy with the necessary read privileges and optionally ALTER TABLE DELETE access.
- 2
TruePrivacy scans ClickHouse tables for personal data columns through schema inspection and sampling.
- 3
DSR requests are matched against ClickHouse records by email address or other configured identifiers.
- 4
Deletion is executed using ClickHouse's ALTER TABLE DELETE mutation, with the mutation status monitored to completion.
Frequently asked questions
ClickHouse uses ALTER TABLE DELETE mutations for data deletion, which are asynchronous operations. TruePrivacy submits the mutation and monitors its completion status — recording the outcome in the audit trail once the mutation is fully applied across all data parts.
Yes. TruePrivacy supports ClickHouse Cloud as well as self-hosted ClickHouse deployments. Connection is via the standard ClickHouse HTTP interface with SSL/TLS.
Connect TruePrivacy to ClickHouse today
Start your free trial and connect ClickHouse in 15 minutes.