HELP TABLE - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

The HELP TABLE statement is used to discover the table schema for a datalake table. The table is specified using <datalake_name>.<database_name>.<table_name> format.

Columns Returned

  • Column name
  • Iceberg or Delta Lake Datatype
  • TD Datatype

Syntax

HELP TABLE <datalake_name>.<database_name>.<table_name>;

Example: Iceberg

help table datalake_iceberg_glue.vim.all_types;
 *** Query completed. 10 rows found. 3 columns returned.
 *** Total elapsed time was 16 seconds.
ColumnName            IcebergType                   TeradataType
-------------    -----------------------         ------------------
c0_bool               boolean                        BYTEINT_DT
c1_dec1               decimal(38, 2)                 DECIMAL16_DT(38,2)
c2_dec2               decimal(18, 2)                 DECIMAL8_DT(18,2)
c3_dec3               decimal(10, 5)                 DECIMAL8_DT(10,5)
c4_date               date                           DATE_DT
c5_timestamp          timestamp                      TIMESTAMP_DT
c6_float              float                          REAL_DT
c7_double             double                         REAL_DT
c8_long               long                           BIGINT_DT     
c9_string             string                         VARCHAR_DT(32000) CHARACTER SET UNICODE

Example: Delta Lake

help table deltalake_glue.vim.all_types;
 *** Query completed. 10 rows found. 3 columns returned.
 *** Total elapsed time was 16 seconds.
ColumnName            DeltaType                    TeradataType
-------------    -----------------------         ------------------
c0_bool               boolean                        BYTEINT_DT
c1_dec1               decimal(38, 2)                 DECIMAL16_DT(38,2)
c2_dec2               decimal(18, 2)                 DECIMAL8_DT(18,2)
c3_dec3               decimal(10, 5)                 DECIMAL8_DT(10,5)
c4_date               date                           DATE_DT
c5_timestamp          timestamp                      TIMESTAMP_DT
c6_float              double                         REAL_DT
c7_double             double                         REAL_DT
c8_long               long                           BIGINT_DT     
c9_string             string                         VARCHAR_DT(32000) CHARACTER SET UNICODE