Tag Archives: data warehouse

The Operational Decision Platform: Palantir, Databricks, Snowflake, and Microsoft Fabric

Closing the Gap Between Data, Insight, and Action. Palantir, Databricks, Snowflake, and now Microsoft Fabric are often compared as if they solve the same problem. They don’t. Most organisations already have the first three layers of the modern data stack in place. And yet, despite significant investment, decision execution remains slow, manual, and inconsistent. Snowflake excels in scalable analytics and data warehousing, Databricks focuses on data engineering and AI model development, while Palantir enables operational decision execution through integrated workflows. Understanding their distinctions and how they complement each other is key to designing effective, modern data architectures.

Continue reading

WTF Is SCD? A Practical Guide to Slowly Changing Dimensions

Slowly Changing Dimensions (SCDs) are how data systems manage attributes that evolve without constantly rewriting history. They determine whether you keep only the latest value, preserve full historical versions, or maintain a limited snapshot of changes. The classic SCD types (0–3, plus hybrids) define different behaviours… from never updating values, to overwriting them, to keeping every version with timestamps. The real purpose of SCDs is to make an explicit choice about how truth should behave in your analytics: what should remain fixed, what should update, and what historical context matters. Modern data platforms make tracking changes easy, but they don’t make the design decisions for you. SCDs are ultimately the backbone of reliable, temporal, reality-preserving analytics.

Continue reading