Sign in Subscribe

Roland Wenzlofsky

Follow me on LinkedIn for daily thoughts on data engineering, Teradata, Snowflake, AI, and the changing IT market: https://linkedin.com/in/rwenzlofsky

https://www.dwhpro.com

Migrating Bulk Loads from Teradata to Snowflake

Big files, real risks, and how not to overspend On Snowflake, COPY INTO scales with the number of files, not the total GB. A single big file equals one unit of work. To go fast and cheap, publish many medium parts (about 100–250 MB compressed), size the warehouse to

Skewed Joins, Straight Answers: A Neutral Guide for Snowflake/Teradata Teams

Fast multi-file export of Teradata query results using only Teradata SQL Assistant

The Teradata AMP Worker Task

Boost Your Teradata Performance - The Critical Role of NOT NULL Declarations

Optimizing Teradata SQL Queries by Avoiding Full Table Scans and Utilizing Secondary Indexes

Learn how to optimize your Teradata SQL performance by leveraging secondary indexes! Avoid full table scans by bypassing the COALESCE function in the WHERE clause.

Outsmarting Teradata Limitations: A Workaround for Teradata Identity Columns in Volatile Tables

Learn how to overcome the hurdle of using Teradata Identity columns with Volatile Tables. Discover a workaround using the 'CREATE TABLE AS' statement.

When Teradata Space Shortage Impacts System Performance

The Pitfalls of Teradata SELECT * Queries

Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars