In Teradata, QUERY_BAND helped us track who ran what and why. In Snowflake, QUERY_TAG brings the same discipline — but fully integrated with usage and cost views.Here’s how to migrate your tagging strategy step-by-step.From QueryBand to Query Tag: Tr...

Hi everyone,I’m excited to share some news — DWHPro has a new website!It will focus on data-warehouse migrations to the cloud, helping professionals move from traditional systems like Teradata to modern platforms such as Snowflake, Databricks, and ot...

Sometimes, a simple rounding rule can change everything. Teradata and Snowflake don’t always agree on how to handle the same number — and the result might surprise you.Read the short explanation here → Read now....— Roland

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...