Teradata Load Times vs. Snowflake Load Times Elasticity is a crucial aspect of contemporary cloud databases like Snowflake that sets them apart from on-premise shared-nothing databases like Teradata. The lower cost (“pay only what you need”) is one of the main advantages. I think this is a very one-sided approach. Databases like Snowflake must first …
Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …
How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The Teradata Solution Great Even Though It Does Not Offer Columnar Processing? Assuming a standard query, a date range selection is frequently made with a WHERE condition imposing a date restriction. However, only a portion of the …
Teradata transitioned to the cloud to prevent disconnection from contemporary cloud-based databases. I will demonstrate the Teradata Cloud solution in AWS and how it addresses crucial aspects such as security, backups, and sizing.
In this blog post, I will show you what you need to pay special attention to when switching from Teradata to Snowflake. We will analyze the impact of running DML statements (e.g., UPDATE or DELETE) in Snowflake and contrast it with Teradata’s Row Storage and Column Storage.
What Are Zero-Copy Clones? We are all familiar with creating table backups before performing specific operations. This is not a significant problem for smaller tables, as duplicates can be swiftly created and any errors can be rectified by reverting to the backup table. If the table is enormous, making a copy can take a long …
Introduction to Teradata in the Cloud Cloud databases are pressuring traditional data warehousing MPP systems. This blog post will illustrate the reasons for this and outline the pros and cons of each database system. The Architecture of an MPP Database System MPP database systems employ a shared-nothing architecture, wherein each node has its own CPU, …
Discover the key architectural differences between Teradata and Snowflake in this informative article. Learn about data distribution, scalability, indexes, workload management, SQL tuning, and more. Read on to find out if Snowflake could be the right fit for your data needs.
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.
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.