327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Learn how to create Teradata recursive queries using either the WITH RECURSIVE clause or CREATE RECURSIVE VIEW statement in this guide. Explore a real-world example of finding the shortest paths in a graph through a recursive solution.
Learn how Teradata and Snowflake minimize IOs to enhance performance. Teradata uses row partitioning while Snowflake relies on micro-partitions.
What is the DIAGNOSTIC HELPSTATS ON FOR SESSION Command in Teradata? Gathering statistics is a crucial aspect of optimizing performance. Collecting statistics requires resources, and it matters whether they are used only once in the ETL process or cover multiple queries’ workloads simultaneously. Fortunately, Teradata’s recent versions can be configured so that the “COLLECT STATISTIC” …
Learn how to export and upload tables using Teradata TPT scripts with bulk loading. Check out our example and recommended load methods here.
The Teradata TO_CHAR Function Utilize the Teradata TO_CHAR function to: This is an example of a numeric expression argument, which can be any of the following data types: BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT/REAL/DOUBLE PRECISION, or NUMBER. The format string, which must be of type CHAR or VARCHAR, represents the second argument (Further information on …
1. Avoid multiple Joins to the same table The shown MAX/CASE rewrite is grouped aggregation, not a window operation. It can collapse duplicate calls and retain unmatched subscribers that the original WHERE rejected; it is not an equivalent replacement without additional cardinality and match assumptions. This example showcases how to apply an ordered analytical function …
Introduction Data lakes have gained significant popularity in recent years as organizations seek more flexible and scalable solutions to store and process their ever-growing volumes of data. While data lakes offer numerous advantages over traditional data storage and processing systems, they also have their fair share of challenges and pitfalls. In this critical article, we …
Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for requests captured by configured DBQL rules. It is a valuable resource for tracking and analyzing query performance, as it contains information about the resources used by each query and the duration of the query. DBQLOGTBL is located in …
Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud. It is worth noting that the same Teradata software runs on these three major cloud providers. This makes it relatively easy to run Teradata on-premise and in these 3 different public clouds …
Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to split tables for maximum parallelism evenly have been unchanged since the beginning. What is new is the ability to create your hash maps. Hash maps, as we usually know them, are also called contiguous maps. If you are not familiar …
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.