Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- order id that changed from not canceled to is canceled because order state is sent to warehouse and created at is more than 7 days
- -- order id: 3486372
- -- user id: 1122144
- -- order id that has not changed because the order state is captured
- -- order id: 3047846
- -- user id: 1716530
- -- order - - Shows that is_canceled is now true
- SELECT * FROM core.orders where id = 3486372
- SELECT * FROM core.orders where user_id = 1710281 order by created_at
- -- order_type - - Column order_type and order_type_detail changed from Existing Customer Manual to Cancel
- -- NOTE: even though it is a canceled order, starts free trial is TRUE -- should this be the case
- SELECT * FROM dtc.order_types WHERE order_id = 3486372
- -- fact_order - - Check that naming changed from canceled --> is_canceled and from False --> True
- SELECT * FROM dw.fact_order where order_id = 3486372
- -- order attributes - - Check that the new column, is_canceled, is apart of the order_attributes table and is accurate
- -- is_canceled = True (changed)
- SELECT * FROM analytics.order_attributes where order_id = 3486372
- -- is_canceled = False (unchanged)
- SELECT * FROM analytics.order_attributes where order_id = 3047846
- -- user_order_stats - - Check that the num_orders has changes from (production) -> (development)
- -- num_orders went from 4 (production) --> 3 (development)
- SELECT * FROM dtc.user_order_stats where user_id = 1710281
- -- num_orders went from 1 (production) --> 1 (development)
- SELECT * FROM dtc.user_order_stats where user_id = 3047846
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement