Stitch BlocklistValues table

The Stitch BlocklistValues table is added to the Stitch QA database as a passthrough table for values identified by the bad-values blocklist, which were excluded from the Stitch process.

Add table

Important

This table cannot be added to the Stitch QA database until after the bad-values blocklist has been configured.

To add the Stitch BlocklistValues table

1. From the Customer 360 page, under All Databases, select the menu for the Stitch QA database, and then click Edit.

2. From the Database Editor, click Add Table.

3. Name the table “Stitch_BlocklistValues”.

4. Set the build mode to Passthrough.

5. From the Source Table drop-down, select the table associated with the bad-values blocklist.

6. Click Next.

7. Add a table description. This enables a tooltip that is visible from other areas in Amperity.

8. Leave everything else unchanged.

9. Click Save.

10. Activate, and then run the Stitch QA database.

Column reference

Column Name	Data type	Description
datasource	String	The data source in which the value was blocklisted.
semantic	String	The semantic tag associated with the blocklisted value.
value	String	The value that was blocklisted.