- Overview
- Platform setup and administration
- Platform setup and administration
- Platform architecture
- Data Bridge onboarding overview
- Connecting a Peak-managed data lake
- Connecting a customer-managed data lake
- Creating an AWS IAM role for Data Bridge
- Connecting a Snowflake data warehouse
- Connecting a Redshift data warehouse (public connectivity)
- Connecting a Redshift data warehouse (private connectivity)
- Reauthorizing a Snowflake OAuth connection
- Using Snowflake with Peak
- SQL Explorer overview
- Roles and permissions
- User management
- Inventory management solution
- Commercial pricing solution
- Merchandising solution
Product extra dataset
Product extra dataset for the Markdown & Promotions module, holding tenant-specific product attributes in key-value format.
The Product extra dataset holds tenant-specific product attributes in a key-value format, allowing additional descriptive data to be attached to products without changing the core Products dataset.
This dataset extends the Products dataset and is joined using the product_id.
Purpose
The Markdown & Promotions module uses the Product extra dataset to:
- Attach custom, tenant-specific attributes to products
- Support segmentation and analysis using attributes not in the core Products dataset
Required fields
About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.
| Field | Description | Type | Constraint |
|---|---|---|---|
product_extra_attribute | Name of the custom product attribute. | string | Primary key |
product_extra_value | Value of the custom product attribute. | string | Primary key |
product_id | Unique identifier for the product SKU. | string | Primary key Foreign key to product |
created_at | Timestamp when the record was created. | timestamp | Nullable |
updated_at | Timestamp when the record was last updated. | timestamp | Nullable |
Usage notes
- Each row represents a single attribute-value pair for a product.
- The
product_idmust reference an existing product in the Products dataset.
Why this dataset matters
Custom attributes let the solution incorporate business-specific product characteristics into markdown and promotion analysis.