A "dimension" table is supposed to have one row per entity. In practice a customer profile gets a new row every time it's updated, and the table that reaches you has three rows for the customer you are about to join against.
Write enrich_orders(orders, customers). orders has order_id, customer_id, amount. customers has customer_id, name, updated_at, and may contain more than one row per customer_id — each one a snapshot of that customer's profile at a point in time.
You have read the opening. The rest is free with a Bezen account, and no card is needed.
Behind the sign-in