How avoid loading micro partitions where only want the latest entry per customer
Imagine I have a vast table of customers, orders, for arg sake trillions of customers each with trillions of orders. I store customer ID, order ID, order time (which has no dupe times per customer). My table is clustered by customer ID, order Time.
How avoid loading micro partitions where only want the latest entry per customer
Imagine I have a vast table of customers, orders, for arg sake trillions of customers each with trillions of orders. I store customer ID, order ID, order time (which has no dupe times per customer). My table is clustered by customer ID, order Time.