DWHPro Insights

Insights

327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.

Stop Comparing Teradata, Snowflake, and Databricks. Start Asking These Questions Instead. Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

A vendor-neutral look at the architectural trade-offs that actually matter I have spent over 20 years building and optimising enterprise data warehouses, mostly on Teradata, and increasingly on Snowflake and Databricks. What I have observed repeatedly is that platform selection decisions are driven by slide decks, analyst quadrants, and licensing pressure — not by the …

Read more

Microsoft Fabric vs. Databricks: What Enterprise Teams Actually Need to Know Popular

Illustration of a person in a suit standing beside a database cylinder

When Microsoft launched Fabric, it promised to unify analytics under one roof. Databricks, meanwhile, has been building its lakehouse platform for years. Both aim to be your central data platform — but they make fundamentally different bets on how much complexity to show you. Having worked across Teradata, Snowflake, and Databricks environments in European banking …

Read more

You Migrated From Teradata to Spark and Threw Away the One Thing That Made It Fast

Illustration of three stacked database units of differing heights inside a circle

If you have spent any amount of time working with Teradata, you know that the Primary Index is one of the most important design decisions you make. It determines how data is distributed across AMPs and whether your joins are fast or slow. Choosing the wrong Primary Index is one of the most common causes …

Read more

Data Warehouse of Horrors: 20 Years of Watching Smart People Build Stupid Things

In the projects I remember, a small team—sometimes five or six people—covered the whole warehouse. These staffing numbers and recalled conversations are personal observations, not an industry benchmark. This was the late 1990s. Data warehousing was young. Teradata was the dominant platform. And the people who built these systems understood, from end to end, what …

Read more

The 15-Year Detour: How the Data Industry Spent Billions Reinventing SQL

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Somewhere around 2020, the data world quietly arrived at a conclusion that Teradata engineers could have told you in 1984: SQL on a massively parallel architecture is a pretty good way to process large volumes of data. The path to get there was anything but quiet. It involved billions in capital, an entire generation of …

Read more