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 Reducing the number of joins to a table is crucial, as each additional join could lead to a full table scan or index access. This can be accomplished by implementing subqueries, volatile tables, or ordered analytical functions. 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 all queries on the system. 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 the …
Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud Storage. 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 …
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 …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.