How Survival Instinct Is Reshaping the Data Warehouse
Every data platform eventually faces the same question: how do you serve both the analyst running a full-table scan across billions of rows…
Snowflake
A collection of 48 issues
5 Things That Break When You Migrate from Teradata to Snowflake
What Twenty Years of Teradata Expertise Won’t Prepare You For
Teradata Join Indexes vs. Snowflake Materialized Views — A Technical and Pragmatic Comparison
From QueryBand to Query Tag
How to Track Query and User Activity After Migrating from Teradata to Snowflake
By Roland Wenzlofsky · DWHPro
🎯 Why This Matters
In Teradata, QUERY_BAND has long been a hidden gem — the ability to tag every query or session with metadata like App, Job, or UserGroup.
That little string became the
Rounding Differences Between Teradata and Snowflake
One of the smallest but most persistent sources of data mismatches during a Teradata-to-Snowflake migration comes from an unassuming function: ROUND().
While both systems follow ANSI SQL semantics, they differ in how they handle values that lie exactly halfway between two rounding candidates (i.e., when the digit after the
Why the Same UPDATE Means Something Entirely Different in Teradata and Snowflake
Teradata Hybrid: Bridge or Destination?
Teradata vs. Snowflake: Why GROUP BY Performance Differs at Scale
Migrating Bulk Loads from Teradata to Snowflake
Skewed Joins, Straight Answers: A Neutral Guide for Snowflake/Teradata Teams
Snowflake’s physical join execution is predominantly hash-based. In practice you’ll observe hash-join variants with two distributions:
* Broadcast hash joins — replicate a small build side to all workers (warehouse nodes) and join locally.
* Partitioned (shuffle) hash joins — repartition both inputs by the join key so matching keys land on