For many years, Teradata was the undisputed leader in large-scale data warehousing. Banks, insurers, and telcos built their most critical systems on it. Today, the market is very different. Cloud-native databases such as Snowflake, BigQuery, and Databricks have set new standards in elasticity and simplicity.
The question is: what role will Teradata play in this new world?
What Teradata Offers with Hybrid
VantageCloud Lake combines a primary cluster and independent compute with managed object storage. This storage/compute architecture is distinct from operating systems across both on-premises and cloud environments.
- Shared-Nothing MPP (classic Teradata): predictable performance for workloads designed around primary indexes.
- Shared-Data MPP (cloud object store): elastic compute nodes reading and writing object storage.
The optimizer plans supported queries within configured data placement and compute capabilities. Existing SQL may be reusable, but workload compatibility, movement, permissions and performance require validation; the optimizer does not transparently migrate every legacy workload.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free bookFor large organizations, this is attractive. It reduces migration risk and protects investments made over decades. It also allows cost optimization by keeping hot data in Teradata storage and moving colder workloads into cheap storage.
The Strengths of the Hybrid Model
- Continuity – Existing queries, reports, and ETL pipelines keep running.
- Lower risk – No “big bang” migration to a new platform.
- Flexible economics – Expensive storage only where needed, cheap storage elsewhere.
- Skills – Teradata experts remain useful, new teams can work on the cloud side.
It is, in many ways, a bridge to the cloud.
Where Hybrid Falls Short
An on-premises/cloud hybrid deployment differs from Lake’s cloud architecture. It inherits much of Teradata’s complexity:
- Two execution models instead of one.
- Data movement between storage layers.
- Ongoing need to manage primary indexes, skew, and statistics.
- Compare delivery of the specific features your workload needs; innovation pace is not established here.
- Talent availability varies by region and role; validate hiring assumptions with current local evidence.
Hybrid buys time. It does not remove the long-term pressure to modernize.
Market Signals
Market position is part of this article’s strategic opinion. No dated revenue or market-share dataset is supplied here, so claims about relative growth should not be read as measured findings.
A Possible Future: Teradata as the Next Mainframe
Here is one possible scenario I see:
- Teradata remains important in industries like banking and insurance.
- Critical, compliance-heavy workloads stay on Teradata.
- New projects and analytics increasingly move to Snowflake, Databricks, or BigQuery.
In this world, Teradata plays a role similar to the mainframe today: still used in a large percentage of global banks, absolutely critical, but ultimately a niche.
Conclusion
I like both Teradata and cloud-native databases. The hybrid model is a sensible intermediate step for large enterprises that cannot risk a full migration today.
But in the long run, I am not sure what Teradata’s strategy will be to hold onto significant market share. The most likely outcome may be that Teradata becomes a specialized system, still vital for certain workloads, but no longer at the center of the data ecosystem.
Deciding what to change in your data platform?
Compare optimisation, modernisation and migration against your workload and business requirements.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free book