Using Additional Validations
š Read more about validation
Additional Validations can be applied to your transformation from the Validation Log tab of your transformation. See below for details on each validation.
| Test Name | Details |
|---|---|
| Check for Missing Columns* | Each kind of transformation has a set of columns that are required. This will validate that the columns are available. |
| Check for ID Duplication* | - For Activity: Validate that activity_id and activity are unique- For Enrichment: Validate that enriched_activity_id is unique |
| Check for NULL Values in Required Columns* | - For Activity: Validate that activity_id, activity, ts and at least one customer column (anonymous_customer_id or customer) are available- For Enrichment: Validate that enriched_activity_id and enriched_ts are available- For Customer: Validate that customer is available |
| Check for LIMIT Clauses* | Ensures the query doesn't have a LIMIT |
| Check for Duplicate Timestamps | Searches for timestamps that are duplicated for the same customer (often caused by double firing). You can dedupe the query to avoid unnecessary activities in your Activity Stream |
| Generate Relationship to Other Activities | (informational) How does the transformation relate to other activities in the Activity Stream? |
| Infer Column Names | (informational) Parses the query to auto-generate default column names |
| Find Sources Used | (informational) Generate the source values used for identity resolution |
| Find Activities Generated | (informational) Find the activities created by the transformation |
*indicates a test that is required to push to production
Additional Reading
Still have questions?
Our data team is here to help! Here are a couple ways to get in touch...
š¬ Chat us from within Narrator
š Email us at [email protected]
š Or schedule a 15 minute meeting with our data team