Example: HELP TABLE for Table in Data Lake - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

This query returns information about the table t1 in the database db1 in the data lake MyIceberg:

HELP TABLE MyIceberg.db1.t1;
 *** Query completed. 2 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.

ColumnName|ColumnType|TDMappingType|
----------+----------+-------------+
c1        |int       |INTEGER_DT   |
c2        |float     |REAL_DT      |

ColumnType is the Iceberg data type. TDMappingType is the Teradata data type.