▲ 17 r/dataengineering
Keep fact tables at grain or pre-aggregate before the BI layer?
Say when you create your star schema, do you typically aggregate the data beforehand, or do you keep the fact table at the defined grain and let the BI tool handle aggregation? Seems like the general consensus is at the BI level but with tools like dbt is it more common prior to being upstreamed to the BI tool?
u/Sheeesh7102 — 1 day ago