Question

How do I locate Personal Identifiable Information (PII) in data synced by different connectors?

Environment

All destinations and connectors

Answer

It looks like there are some sources that have tools to identify PII already that may help with locating the PII:

• GCP have the Data Loss Prevention tool which automatically scans BQ for PII
• Businesses that use FB Ads can also modify the pixel tracking configuration to align to GDPR & CCPA by following the process to implement a pause for firing pixels unless consent is granted.

Cause

Fivetran offers customers a robust Data Processing Agreement (“DPA”), governing the relationship between the customer (acting as a data controller) and Fivetran (acting as a data processor). So in this case, the customer being the data controller, is expected to know the PII that is coming in from the sources and hence, locating PII needs to be manual.