Snowflake’s Evolving Table Types, Services, and Administrative Choices
Snowflake in 2026 is not the platform you onboarded onto. The question is whether your team has noticed.
Why Two Identical Teradata Migrations Produce Wildly Different Snowflake Costs Popular
Migration success stories are everywhere. A quick search reveals case studies of companies that moved from Teradata to Snowflake and achieved faster queries, lower total cost of ownership, and happier analysts. Vendors publish them. Consultants reference them. Conference speakers present them as evidence that the migration path is well-trodden and safe. These stories are not …
The Medallion Architecture Is Not New. We Just Called It Something Else. Widely read
Why data warehouse professionals have been doing “bronze, silver, gold” for over 20 years. If you have been working in data warehousing for any length of time, the first time you heard about the “medallion architecture” you probably had one reaction: We already do this. You were right. The medallion architecture, popularized by Databricks as …
5 Things That Break When You Migrate from Teradata to Snowflake
Most organizations approach a Teradata-to-Snowflake migration as a translation exercise: convert the SQL, move the data, and validate the results. The technical migration succeeds. Then the first quarterly bill arrives at double the projected budget, dashboards queue for 20 minutes during batch windows, and data-loading pipelines that ran in 45 minutes on Teradata now take …
Coming soon: A Modern Web-Based Alternative to Teradata Studio
Introducing DWHPro Query Master: A Modern Web-Based Alternative to Teradata Studio As Teradata professionals, we’ve all been there: waiting for Teradata Studio to launch, dealing with Java updates, or struggling with its dated interface when all we want to do is run a quick query. That’s why I’m excited to introduce DWHPro Query Master – …
Teradata Join Indexes vs. Snowflake Materialized Views — A Technical and Pragmatic Comparison Popular
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 and design. The intention of this …
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 key to workload …
Rounding Differences Between Teradata and Snowflake
Rounding differences can cause migration mismatches, but distinguish the ROUND function from CAST and arithmetic scale reduction. Do not infer one operation’s behavior from another or from a database setting alone. ROUND and CAST in Teradata On Teradata Database 20.00.28.81, the audit returned 1.30 for ROUND(DECIMAL 1.25,1), 1.40 for ROUND(1.35,1), and -1.30 for ROUND(-1.25,1). CAST …
BTEQ Multi-Statement Requests: Transaction Boundaries and Migration
In BTEQ, request boundaries matter. A semicolon that terminates the first SQL statement at the end of a line sends that request before the next line is read. Adding another semicolon at the start of the next line does not combine an already-submitted request. Correct multi-statement request formatting There is no trailing semicolon on the …
Understanding Skew in Teradata and Snowflake Popular
Performance degradation caused by uneven workload distribution is one of the oldest and most persistent challenges in parallel data warehouse systems. Both Teradata and Snowflake can experience this imbalance, commonly known as skew. Although the term is shared, the mechanics differ fundamentally: Teradata can suffer from both persistent and runtime skew, whereas Snowflake’s skew occurs …