0520_UOS_BAS_SHOPIFY_transactions Transformation

Target Database Table

uos.transactions.

Script Description and Logic

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

Source Tables Used In Script

Coming soon.

SQL Flow

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

0520_UOS_BAS_SHOPIFY_transactions Transformation

Calculated and Derived Fields

 Coming soon.

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