Modern Database Analytics

Big Flat Fact Tables

This blog post was authored by Steve Sarsfield. For decades, it's been widely accepted that snowflake and star schemas facilitate getting optimal performance from your data warehouse. You normalize data by identifying the rows of data that you typically ingest, and creating a schema that is optimized for the types of queries you want to...