Setting Table-level Retentiondays | - Create Table: Setting Table-level Retentiondays - Teradata Vantage

Teradata® Open Table Format for Apache Iceberg and Delta Lake User Guide
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
October 2025
ft:locale
en-US
ft:lastEdition
2026-06-17
dita:mapPath
qrj1749167830193.ditamap
dita:ditavalPath
lli1749584660955.ditaval
dita:id
bsr1702324250454

The table creation syntax itself has not changed. However, default table-level retentiondays can now be inherited from the database, profile, or user when a table is created. The inheritance order is:

  1. Table-level setting (if explicitly specified)
  2. Profile default - NEW
  3. Database/User default - NEW
  4. Fallback behavior:
    • OFS tables: If no table-level or inherited value is available, the table uses the storage-level retentiondays.
    • MOTF tables: If no table-level or inherited value is provided, the default retention is 30 days.