For the "Aggregations" table, you mentioned using "Period" as the primary key of GSI, but Period is not unique among the customers. Do we need to use Period + custom ID as the primary key?
Please let me know if I missed anything, thanks!
In that example, I was referring to being able to get an aggregate across all customers, so we would not need to include the customer id. We could just pull Period and TotalPurchases then add them up locally. The specific example in the AWS documentation uses a single row that’s updated frequently as a counter. This link might help explain it better: