0516_UOS_BAS_SHOPIFY_order_line_Items Transformation

Target Database Table

uos.order_line_items.

Script Description and Logic

Pulls orders line items in Shopify created or modified in the 7 days prior to the script run date along with order line ids, flags, and other associated data. The data is loaded into a unified schema that combines order line, refund line items, and discount data from Shopify with data from any other order line item source integration.

Source Tables Used In Script

Coming soon.

SQL Flow

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

0516_UOS_BAS_SHOPIFY_order_line_Items Transformation

Calculated and Drived Fields

Coming soon.

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