Super interesting approach, thanks for the sharing your thoughts! Just out of curiosity, how do you see architecture layering when end users (whether it'd be business users or a BI Tool) when the desire info is pre-aggregated state AND entity level break down. Would you say then best to provide access to both Core and Mart? Or this varying level of granularity should only be present in Mart? So perhaps another way of asking, should table with customer level purchases table and headline figures of purchases per cohort need to reside in Mart or one the first in Core and the latter in Mart?
Super interesting approach, thanks for the sharing your thoughts! Just out of curiosity, how do you see architecture layering when end users (whether it'd be business users or a BI Tool) when the desire info is pre-aggregated state AND entity level break down. Would you say then best to provide access to both Core and Mart? Or this varying level of granularity should only be present in Mart? So perhaps another way of asking, should table with customer level purchases table and headline figures of purchases per cohort need to reside in Mart or one the first in Core and the latter in Mart?