Dear DWHPro reader,UPDATE looks identical in SQL — but in Teradata and Snowflake, it works in completely different ways.Teradata updates data blocks in place with journals and WAL.Snowflake rewrites partitions and commits through metadata.The impact?...

Are you migrating your data pipelines from Teradata to Snowflake? In my latest blog post, I break down how Snowflake’s COPY INTO paradigm differs from Teradata’s FastLoad — and how one big file could cost you performance and credits. Dive in to learn...

Dear DWHPro Community,In the rapidly evolving landscape of data management, it's crucial to acknowledge the enduring significance of established technologies amidst the rise of new trends.Similar to how mainframes have been declared obsolete numerous...

Hi,Data import tasks often push the boundaries of our systems. Recently, I supported a project involving importing a Teradata-generated CSV file containing nearly 60 million rows into a third-party database. The large scale of data led to system cras...

Hi,Improve your Teradata system's efficiency with optimal AMP Worker Task (AWT) management. Explore the delicate balance between increasing AWTs and maintaining system stability. Understand the importance of considering AMPs per node, using AWTs as t...

Hello,We've got some fresh insights on optimizing your Teradata database in our latest blog post! Have you ever wondered how defining a column as NOT NULL can dramatically impact your database performance?Join us in our deep dive into SQL queries and...

Dear valued reader,Since our inception, DWHPro has been your dedicated source of information and insights about Teradata. Over the years, we've enjoyed helping you navigate the vast landscape of Teradata databases. We are grateful for your continued...

Hi,Boosting your SQL query performance can be as simple as rethinking the use of functions like COALESCE in the WHERE clause:SELECT * FROM DWHPRO.INDEX_USAGE WHERE COALESCE(TheStartDate,TheEndDate) = DATE'2022-10-10'; When used on indexed columns, it...

Dear Subscriber,We understand that you may encounter difficulties with Teradata Identity Columns and Volatile Tables. As such, we are pleased to announce a recently published blog post that directly addresses this prevalent issue.Despite the inherent...

Hello,Struggling with Teradata space management? Discover essential strategies in our new blog post:Understand the role of free cylinders and the impact of their exhaustion.Learn about automatic mechanisms like Defragmentation and Mini-Cylinder Packs...