Example: SELECT from VSD_DATABASESV[X] Statements - 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

The SELECT statement supports queries on the virtual view: VSD_DATABASESV[X].

Example:

Select contents from all the databases on the iceberg_glue catalog.

SELECT * FROM vsd_databasesv WHERE CatalogName =' iceberg_glue ' ;
*** Query completed. 218 rows found. 26 columns returned.
*** Total elapsed time was 23 seconds.