Householding Code
This page provides detailed instructions on the Householding Code transform code block and what should be added to the Script Manifest file in order to execute the code
Script Manifest File (YML)
Upstream Transformation Dependencies
This block is dependent on the following blocks being implemented:
Initialization
UOS
Transformation Code Requirements
The following code should be added to the main workflow in the appropriate position, after UNS and before Google Analytics per the Transform Code Sequence - DRP page
#--------------------------------------------------------------------------------------------------------------------
# SECTION: 2300_HOUSEHOLDING
# DEPENDENCIES:
# - Section: 0500_UOS
# REQUIRED: No
# PURPOSE: These scripts perform householding across the different Commerce integrations using the UOS data model
# and should be enabled when UOS is enabled
#--------------------------------------------------------------------------------------------------------------------
householding:
integrations:
- shopify
- amazon_seller_central
- skubana
scripts:
- "github://platform-sql-shared/scripts/base/2300_householding/2310_HSH_BAS_customer_order_lkp.sql"
Householding
Add this script in the appropriate section to household across different commerce integrations. This must be included in order to create a unique customer identifier that is used in the data model
Create the [uos.customer_hshld_lkp
] and [uos.order_hshld_lkp
] tables
Was this helpful?