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
- Type
- Comment
- Nullable
- Format
- Title
- Max Length
- Decimal Total Digits
- Decimal Fractional Digits
- Uppercase
- Default Value
- Char Type
- IdCol Type
- UDT Name
- Temporal
- Column Dictionary Name
- Column SQL Name
- Column Name UEscape
- Dictionary Title
- SQL Title
- Title UEscape
- UDT Dictionary Name
- UDT SQL Name
- UDT Name UEscape
- Inline Length
- Time Series Column Type
- Auto Column
- OTF Type
- OTF Table Format
Syntax
HELP TABLE <datalake_name>.<database_name>.<table_name>;
Example: Iceberg
help table datalake_iceberg_glue.vim.all_types; *** Help information returned. 3 rows. *** Total elapsed time was 16 seconds. Column Name c0_bool Type I1 Comment ? Nullable Y Format ? Title ? Max Length 1 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c0_bool Column SQL Name c0_bool Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type boolean OTF Table Format iceberg Column Name c1_dec1 Type D Comment ? Nullable Y Format ? Title ? Max Length 0 Decimal Total Digits 38 Decimal Fractional Digits 2 Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c1_dec1 Column SQL Name c1_dec1 Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type decimal(38, 2) OTF Table Format iceberg Column Name c2_dec2 Type D Comment ? Nullable Y Format ? Title ? Max Length 0 Decimal Total Digits 18 Decimal Fractional Digits 2 Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c2_dec2 Column SQL Name c2_dec2 Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type decimal(18, 2) OTF Table Format iceberg Column Name c3_dec3 Type D Comment ? Nullable Y Format ? Title ? Max Length 0 Decimal Total Digits 10 Decimal Fractional Digits 5 Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c3_dec3 Column SQL Name c3_dec3 Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type decimal(10, 5) OTF Table Format iceberg Column Name c4_date Type DA Comment ? Nullable Y Format ? Title ? Max Length 4 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c4_date Column SQL Name c4_date Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type date OTF Table Format iceberg Column Name c5_timestamp Type TS Comment ? Nullable Y Format ? Title ? Max Length 19 Decimal Total Digits 60 Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c5_timestamp Column SQL Name c5_timestamp Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type timestamp OTF Table Format iceberg Column Name c6_float Type F Comment ? Nullable Y Format ? Title ? Max Length 89 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c6_float Column SQL Name c6_float Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type float OTF Table Format iceberg Column Name c7_double Type F Comment ? Nullable Y Format ? Title ? Max Length 89 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name c7_double Column SQL Name c7_double Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type double OTF Table Format iceberg
Example: Delta Lake
help table deltalake_glue.vim.tab1; *** Help information returned. 29 rows. Column Name key_temp Type CV Comment ? Nullable Y Format ? Title ? Max Length 2000 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 2 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name key_temp Column SQL Name key_temp Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type string OTF Table Format deltalake Column Name fare_amount Type D Comment ? Nullable Y Format ? Title ? Max Length 0000 Decimal Total Digits 7 Decimal Fractional Digits 2 Uppercase ? Default Value ? Char Type 0 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name fare_amount Column SQL Name fare_amount Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type Decimal(7, 2) OTF Table Format deltalake Column Name fare_bin Type CV Comment ? Nullable Y Format ? Title ? Max Length 2000 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 2 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name fare_bin Column SQL Name fare_bin Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type string OTF Table Format deltalake Column Name pickup_datetime Type CV Comment ? Nullable Y Format ? Title ? Max Length 2000 Decimal Total Digits ? Decimal Fractional Digits ? Uppercase ? Default Value ? Char Type 2 IdCol Type ? UDT Name ? Temporal ? Column Dictionary Name pickup_datetime Column SQL Name pickup_datetime Column Name UEscape ? Dictionary Title ? SQL Title ? Title UEscape ? UDT Dictionary Name ? UDT SQL Name ? UDT Name UEscape ? Inline Length ? Time Series Column Type ? Auto Column ? OTF Type string OTF Table Format deltalake