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
Database features should be compared based on their documented behavior, their operational impact, and the architectural principles behind them. This applies especially to physical optimization structures such as Teradata Join Indexes (JIs) and Snowflake Materialized Views (MVs)—two features often mentioned together during migration planning, yet substantially different in scope
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
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