SQL is dead. The future is MapReduce.Ok, we need SQL on Hadoop. Here's Hive.Hive is too slow. The future is Spark.OK, we need SQL on Spark. Here's Spark SQL.Notice a pattern?Teradata had this figured out in the 1980s. I wrote the full timeline.Read t...
If two companies migrate the same Teradata system to Snowflake, with the same data, indexes, statistics, and workloads, will they get the same bill?They will not. And the reason has less to do with warehouse sizing or SQL translation than most teams...
Your Teradata expertise is valuable. But carried into Snowflake unchanged, it can cost you. This article covers five areas where experienced Teradata professionals get tripped up: your cost model (fixed licensing vs. pay-per-second), your query optim...
I’m excited to introduce DWHPro Query Master – a lightweight, modern web application designed specifically for Teradata users who value speed, simplicity, and powerful features.Soon there will be a demo version available. In the meanwhile p...
Hi,Most people try to fix performance problems by throwing more hardware, more credits, or more magic features at the system.After 20 years tuning some of the largest Teradata and cloud data warehouses in Europe, I’ve learned something much simpler:U...
In Teradata, QUERY_BAND helped us track who ran what and why. In Snowflake, QUERY_TAG brings the same discipline — but fully integrated with usage and cost views.Here’s how to migrate your tagging strategy step-by-step.From QueryBand to Query Tag: Tr...
Hi everyone,I’m excited to share some news — DWHPro has a new website!It will focus on data-warehouse migrations to the cloud, helping professionals move from traditional systems like Teradata to modern platforms such as Snowflake, Databricks, and ot...
Sometimes, a simple rounding rule can change everything. Teradata and Snowflake don’t always agree on how to handle the same number — and the result might surprise you.Read the short explanation here → Read now....— Roland
Dear DWHPro reader,UPDATE looks identical in SQL — but in Teradata and Snowflake, it works in completely different ways.Teradata updates data blocks in place with journals and WAL.Snowflake rewrites partitions and commits through metadata.The impact?...
Are you migrating your data pipelines from Teradata to Snowflake? In my latest blog post, I break down how Snowflake’s COPY INTO paradigm differs from Teradata’s FastLoad — and how one big file could cost you performance and credits. Dive in to learn...