PII cleanup template

This template enables you to delete Personal Identifiable Information (PII) data of customers in bulk.

Perform the following steps:

1. In the Connect to Source Block, enter the source server details. See Connect to source.

2. In the Decrypt data block, if the files are encrypted, enter the details to decrypt the data. See Decrypt data.

3. In the Data-Validation-Block, validate or transform data using a Databricks notebook. For more details, refer to Data-Validation-Block. The block is optional, meaning you can skip it without affecting the dataflow. If you choose to enable it, the rest of the dataflow continues as usual after the execution of the block.

4. In the Transform data block, enter the transformation details and map the API fields.

   API Field	Transformation	Example
   source	Customer registration source	Wechat, web_engage etc
   identifierType	Customer identifier type	Mobile, e-mail etc
   identifierValue	Customer identifier value for the defined identifier type	mobile number, e-mail id etc
   type	Type of request. In this case, the value should be CUSTOMER.	Customer
   baseType	Subtype of the request. In this case, the value should be DELETE.	Delete
   accountId	Account id of the sources with multiple accounts. This is required only if there are multiple accounts of the same source.	123344
   comments	Additional comments if any	Any comment

5. In the Connect to destination block, enter the PII deletion API endpoint details (https://<host>/v2/requests). See Connect to destination.
   For information on PII deletion API endpoint, see PII deletion API documentation.

6. Set the trigger frequency. See Trigger frequency.

📘

If the brand has multiple source profiles, for every source profile you need not run this flow multiple times. During the first run itself, the dataflow deletes both profile's PII data.