Blog Posts

Latest news and updates from our team

The Reference Data Layer Your Data Warehouse Is Missing

Your warehouse has a staging layer, a transformation layer, and a presentation layer. It doesn't have a reference data layer. That's why your dimensions are a mess.

Why dbt Seed Files Are the Wrong Place for Reference Data

*dbt is brilliant at transformation. Seed files are not a reference data management strategy. Here's why the workaround breaks - and what to use instead.*

Your Lookup Tables Shouldn't Live in Excel

Every data team has them. Nobody manages them properly. Here's why that's a bigger problem than you think — and what to do about it.