Tagged with

4 articles found

SCD2 in API Ingestion: The Historization Hammer Smashing Every Nail

Should every API payload get the full SCD2 treatment? A pragmatic look at when dimension tracking is critical, when it’s dangerous, and how to build resilient ingestion without the overhead.

#API ingestion#Data Engineering#Data Modeling...

best practices

dbt Best Practices Are a Floor, Not a Ceiling, Here’s Where to Build Higher

"{{ doc(‘customer_id’) }}"

#best practices#Data Engineering#Data Modeling...

Data Modeling

The Star Schema Cult vs. the Snowflake Heretics: Who’s Actually Right About Your Data Warehouse?

Denormalized performance or normalized maintainability? The dimensional modeling debate heats up when 10x growth is on the line.

#Data Modeling#data warehousing#dimensional modeling...

Data Engineering

The Medallion Architecture Civil War: Silver vs. Gold for Fact and Dimension Tables

A Reddit debate exposes the dirty secret of medallion architecture: nobody agrees where fact and dimension tables actually belong. Here’s what the BigBasket case study reveals.

#Data Engineering#Data Modeling#dimension tables...