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