Coming soon: A Modern Web-Based Alternative to Teradata Studio Popular

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

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 – …

Read more

Teradata Join Indexes vs. Snowflake Materialized Views — A Technical and Pragmatic Comparison Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

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 …

Read more

From QueryBand to Query Tag

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

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 …

Read more

Rounding Differences Between Teradata and Snowflake Popular

Illustration of an entity-relationship diagram, boxes joined by arrows

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 …

Read more

BTEQ Multi-Statement Requests: Transaction Boundaries and Migration

Icon of a chrome hammer inside an orange circle over a brick pattern

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 …

Read more

Understanding Skew in Teradata and Snowflake Popular

Icon of a chrome hammer inside an orange circle over a brick pattern

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 …

Read more

Why the Same UPDATE Means Something Entirely Different in Teradata and Snowflake Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

At first glance, an UPDATE looks universal.In reality, it’s one of the most misleading similarities between Teradata and Snowflake.The SQL is the same, but the storage, logging, recovery, and performance mechanics are completely different. If you’re migrating from Teradata to Snowflake (or running both), understanding these differences prevents slow jobs, unnecessary costs, and avoidable outages. …

Read more

Teradata Hybrid: Bridge or Destination?

Icon of a chrome hammer inside an orange circle over a brick pattern

For many years, Teradata was the undisputed leader in large-scale data warehousing. Banks, insurers, and telcos built their most critical systems on it. Today, the market is very different. Cloud-native databases such as Snowflake, BigQuery, and Databricks have set new standards in elasticity and simplicity. The question is: what role will Teradata play in this …

Read more

Teradata vs. Snowflake: Why GROUP BY Performance Differs at Scale

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

When migrating analytical workloads from Teradata to Snowflake, one subtle but important performance factor often gets overlooked: how the two systems handle GROUP BY operations on huge tables. The SQL looks the same, but the execution engines behave differently. If you’ve relied on Teradata for years, you may be surprised by Snowflake’s behavior. GROUP BY …

Read more

Migrating Bulk Loads from Teradata to Snowflake

Icon of a chrome hammer inside an orange circle over a brick pattern

Big files, real risks, and how not to overspend Snowflake load parallelism depends on format and file options as well as file count. Qualifying large uncompressed CSV files support parallel scanning. Multiple moderately sized files can help, but one file is not universally one thread. Start with roughly 100–250 MB compressed parts as a guideline …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam