What is an enrichment table?
An enrichment table is used to add additional features (columns) to any activity. Each activity can have it's own enrichment table, and a single enrichment table can be updated by one or many enrichment transformations.
Do you need an enrichment table?
You need enrichment tables much less often than you'd think! Also, enrichment tables can slow down your queries when you need to use them in a dataset so they should be used sparingly.
Columns in an Enrichment Transformation
An enrichment transformation generates a dataset with two required columns (which are used to map to the corresponding activity that it is enriching) and any number of additional columns which are the additional features used for enrichment.
Column | Description |
|---|---|
| activity_id of the activity (or activities) that the enrichment table will enrich |
| Timestamp in UTC of the activity (or activities) that the enrichment table will enrich |
features columns | (optional) These columns are the additional features used to enrich an activity or activities. The names should be descriptive of the data they represent (as opposed to the generic feature_1, feature_2, feature_3 naming used for activities). |
How To: Create an Enrichment Transformation
Watch this step-by-step tutorial to create an enrichment transformation.
Examples
Explore the transformation library for examples by data source.
FAQ
- I need more features, should I create an enrichment table?
- How to borrow features from other activities
- How do I link an activity with its enrichment table?
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]
Updated about a month ago
What's Next
| Validation |
| Spend Transformations |