Sign in Subscribe

Snowflake

A collection of 48 issues

Teradata vs Snowflake: A Comparison of Volatile and Temporary Tables

Introduction to Teradata Volatile Tables and Snowflake Temporary Tables Teradata and Snowflake offer temporary tables. This post will compare and contrast the types of tables available on each platform. We will examine table types found only in Teradata and Snowflake and show their ideal use cases. What is the equivalent

Evaluating the Accuracy of Table Statistics: Why Collection Date May Not Be Enough

Learn how to accurately evaluate the statistics of a table beyond just the collection date. Find out how to test the validity of your table's statistics with a simple query.

Maximizing Efficiency: Teradata vs. Snowflake Partitioning

Learn how Teradata and Snowflake minimize IOs to enhance performance. Teradata uses row partitioning while Snowflake relies on micro-partitions.

Track and Optimize Query Performance with Teradata DBQLOGTBL System Table

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.

Teradata COALESCE Function: Purpose, Syntax, Alternative and Data Types

What is the purpose of the Teradata COALESCE function?COALESCE receives a list of scalars as arguments and returns the first value that is not NULL. If all scalars are NULL, then COALESCE returns NULL. What is the syntax of the Teradata COALESCE function?SELECT COALESCE(skalar1, skalar2, skalar3,...,skalarN)

Data Modeling and the Teradata FSLDM

Overview * What is A Data Model? * What are the Major Types of Data Models? * What is FS-LDM? * How is FS-LDM Implemented? Dimensional Modeling * Dimensional Modeling (DM) is a modeling technique in data warehousing, visually represented as a fact table surrounded by dimension tables. * Some of the terms commonly used in

Teradata Pro is now DWH Pro!

DISTINCT vs. GROUP BY: Understanding Performance Differences Based on Data Demographics in Teradata

Over the years, numerous debates have emerged concerning the superior performance of specific statements: SELECT <COLUMN> GROUP BY 1 or SELECT DISTINCT <COLUMN> Many personal experiences are often shared but tend to misattribute causality. People usually construct a single test scenario and extrapolate sweeping conclusions from