Skip to content
Menu

Joining Transaction Data in the Customer 360

About this course

This lesson explores how to prepare and refine data using Custom Domain Tables (CDTs) within Amperity, specifically for integrating transaction and product catalog information. A key focus is on ensuring data is structured correctly to meet Amperity's specific requirements for transaction processing. The lesson demonstrates how to address common data challenges, such as reorganizing complex data columns into a more usable format for the platform. This transformation involves writing SQL to combine various datasets and perform necessary data manipulations. A critical feature highlighted is the ability to test and refine this SQL directly within the system using a Spark SQL session, allowing for immediate validation and debugging of the data transformations. This ensures that the data is perfectly prepared before it's semantically tagged and processed by Amperity's specialized pipelines.