0542_UOS_BAS_AMAZON_customers Transformation

Target Database Table

uos.customers.

Script Description and Logic

Pulls customers in Amazon from asc orders created or modified in the 7 days prior to the script run date along with customer id, addresses and other associated data. The data is loaded into a unified schema that combines customer data from Amazon with data from any other customer source integration.

Source Tables Used In Script

Coming soon.

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab.

 0542_UOS_BAS_AMAZON_customers TransformationCalculated and Derived Fields

Coming soon.

All content © Daasity 2021. Do not copy, share or distribute.