Denormalized records

Use this query to look for foreign key clusters with large row expansions for denormalized records. This query performs “3 times 3 times 3” or “5 times 5 times 5” denormalization with a maximum of five rows that contain columns for email, phone, and address values and provides a condensed option for examining PII values.

Configure query

1. From the Queries page, open the Stitch QA folder, and then select this query.

   Tip

   Add the Stitch QA queries template folder if it does not already exist.

2. Update the uc_filter_query to the desired threshold, which is set to “50”.

3. Click Run Query and debug any issues that may arise.

4. Click Activate.