6510_PLN_BAS_sku_attributes Transformation

Target Database Table

drp.sku_attributes

Script Description and Logic

Pulls the sku, hierarchy information, and product related data of a sku at the sku level. Products from all integrations are included in the primary source table, uos.product_variants, and reported by unique sku and shop.

The code looks back to pull the product variants that have been updated or created in the last 7 days. A list of products is generated from uos.products at the sku level and staged for insertion. The records in staging are compared to those in the final table.

Any skus that match are removed from the final table and updated by way of insertion from staging (upsert). The records that appear in staging, but not in the final table are inserted into drp.sku_attributes.

Source Tables Used In Script

Coming soon.

SQL Flow

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

6510_PLN_BAS_sku_attributes TransformationCalculated and Derived Fields

Coming soon.

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