Authorized Column Filters | VantageCloud Lake - Authorized Column Filters - 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
2025-10-25
dita:mapPath
qrj1749167830193.ditamap
dita:ditavalPath
lli1749584660955.ditaval
dita:id
bsr1702324250454
/*
* otfdb.cardata_lf is a Lake Formation table with five columns: price, make, mileage, dt, country.
* There are three cell filters: price, make, and column
* The query below shows the authorized columns for the table, derived
* from the cell filters
*/
help table aws_lakeformation.otfdb.cardata_lf;
*** Help information returned. 3 rows.
*** Total elapsed time was one minute and 21 seconds.
ColumnName
---------------------------------------------------------------------------
price
mileage
make
+---------+---------+---------+---------+---------+---------+---------+----
select * from aws_lakeformation.otfdb.cardata_lf;
*** Query completed. 590 rows found. 3 columns returned.
*** Total elapsed time was one minute and 41 seconds.
price mileage make
---------------------- -------------------- -------------------------------
2.18781200000000E 004 23237 Buick
1.48620938700000E 004 24021 Buick
2.09522178000000E 004 20158 Buick
2.34930823000000E 004 20453 Buick
1.59518111700000E 004 26070 Chevrolet