0519_UOS_BAS_SHOPIFY_order_payments Transformation

Target Database Table

uos.order_payments.

Script Description and Logic

Pulls order payment gateway names in Shopify created or modified in the 7 days prior to the script run date along with payment ids, order ids and other associated data. The data is loaded into a unified schema that combines order payment gateway names from Shopify with data from any other order payment source integration.

Source Tables Used In Script

Coming soon.

SQL Flow

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

Calculated and Derived Fields

Coming soon.