Utilities & Loading
A collection of 89 issues
Coming soon: A Modern Web-Based Alternative to Teradata Studio
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
Teradata’s Semicolon Optimization vs. Snowflake’s Architecture — Two Worlds, One Goal
1. The Forgotten Performance Trick: A Semicolon That Saves Time
For decades, Teradata developers have quietly used one of the smallest but most powerful performance optimizations in BTEQ:
a semicolon at the start of a line.
INSERT INTO SALES_EU SELECT * FROM SALES_SRC WHERE REGION='EU';
;INSERT
Migrating Bulk Loads from Teradata to Snowflake
Fast multi-file export of Teradata query results using only Teradata SQL Assistant
The Teradata AMP Worker Task
Introduction to the Teradata AMP Worker Task
The Teradata AMP Worker Task or AWT is the heart of the AMP, responsible for executing tasks and ensuring the smooth functioning of the system. AWTs are threads that process incoming tasks in the AMP. Each AMP has a finite pool of AWTs,
When Teradata Space Shortage Impacts System Performance
Effortlessly Loading a CSV File into Teradata using Python
Learn how to easily load a CSV file into a Teradata database using Python with minimal code. No need for complex scripts or ETL tools. Read more.