Open table formats (OTFs): Unparalleled choice for data access
file_copy Open table formats (OTFs)

Unparalleled choice for data access

Organizations seek ways to reduce data management costs and complexity. Moving, replicating, and transforming data across systems is time-consuming and often results in unsynchronized data stored in multiple silos.

Customers experience greater choice, interoperability, and cost efficiency when using Teradata’s open table formats with open catalog integration—without sacrificing the powerful and scalable engine that differentiates Teradata in its ability to optimize value and business outcomes.

Delivering the most open and connected ecosystem for Trusted AI

Key features

Simplify data storage with open table formats

Teradata VantageCloud and Teradata AI Unlimited include support for open table format (OTF) data stores, expanding customer choice for data storage and management. Teradata offers freedom of choice with first-party support for Apache Iceberg and Delta OTFs, leveraging object stores like AWS S3, Azure Data Lake Storage, and Google Cloud Storage.

OTFs provide a standardized storage abstraction layer that defines the structure and rules for how analytical engines interact with data in object storage. This architecture enables you to maintain a single data store for use by multiple analytical engines and tools without needing to host, replicate, and manage multiple copies of large datasets.

Together with OTFs, VantageCloud and AI Unlimited deliver access to the connected data foundation for Teradata’s industry-leading AI + Knowledge Platform for harmonized data and other key capabilities.

  • Atomicity, consistency, isolation, and durability (ACID) transactions: Ensure transactional consistency for multiple, concurrent read and write operations.
  • Schema evolution: Modify schemas (column definition, order, and data types) or partitions without re-creating new tables or partitions, saving time and data movement costs.
  • Time travel: Return to previous table states for historical analysis across time periods.
  • Rollback: Revert to prior versions to quickly correct issues and return tables to a known good state.
First-party services and open catalogs

Teradata’s approach to OTFs

Teradata provides an open ecosystem for OTFs, catalogs, and cloud service providers (CSPs) in multi-cloud and multi-data lake environments.

Teradata provides an open ecosystem for OTFs, catalogs, and cloud service providers (CSPs) in multi-cloud and multi-data lake environments.

This unique, open, and connected approach to supporting OTFs enables cross-read, cross-write, and cross-query of data stored in Apache Iceberg and Delta Lake tables using open catalogs such as AWS Glue, Hive Metastore, or Unity.

This future-ready approach allows enterprises to employ a truly modern data strategy, with unmatched agility and flexibility to deliver Trusted AI at scale—all without the need to move, replicate, or transform data.

Accelerating externally managed OTF performance

Externally managed open table formats (OTFs) allow organizations to retain full control over their data architecture while leveraging Teradata’s high-performance capabilities. With native VantageCloud support for high-performance Iceberg reads, Teradata delivers fast, efficient queries directly against customer-managed OTF lakehouses, without requiring infrastructure changes.

Teradata’s OTF implementation optimizes performance for parallel processing of shared data by leveraging world-class features, such as AMP parallelism, cost-based query optimization, and intelligent workload management. This ensures scalable, responsive analytics across large datasets and diverse environments.

Take advantage of OTFs across our cloud-native, multi-cloud, and on-demand offerings

Enterprises can leverage the powerful analytical engines of VantageCloud and AI Unlimited against their own datasets, in their own cloud object stores—enabling an agile approach without the challenge and expense of moving data.

Learn more about OTFs

Connect with an expert to discover how to:

  • Accelerate innovation and maximize value
  • Deliver harmonized data and Trusted AI
  • Minimize costs and complexity