Dictionary Updates for Retention Settings | - Dictionary Updates for Retention Settings - 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 DATABASE and PROFILES views now include a new column, DefaultRetentionDays, along with a column comment. This column returns the default table-level retentiondays value defined for each database or profile.

?        DBC.DatabasesV
?        DBC.DatabasesVX
?        DBC.DatabasesV_SZ   (The _SZ views should only be created on a system configured with secure zones.)
?        DBC.ProfileInfoV
?        DBCProfileInfoVX
?        DBC.ProfileInfoV_SZ (The _SZ views should only be created on a system configured with secure zones.)