Queries Trino and prints all columns for a specific table, including their data types, extra metadata, and descriptions.
Syntax #
1
2
lakeql-cli list-columns [options]
Usage #
1
2
lakeql-cli list-columns --catalog hive --schema analytics --table users
1
2
3
4
5
6
7
8
9
┌─────────────┬──────────┬───────┬─────────────────────┐
│ Column Name │ Type │ Extra │ Description │
├─────────────┼──────────┼───────┼─────────────────────┤
│ id │ varchar │ │ Unique identifier │
│ email │ varchar │ │ User email address │
│ created_at │ timestamp│ │ Account creation ts │
│ is_active │ boolean │ │ Whether user active │
└─────────────┴──────────┴───────┴─────────────────────┘
Options #
--catalog <catalog>
catalog to use
| Property | Value |
|---|---|
| Type | string |
| Required | No |
| Env var | HIVE_CATALOG |
--schema <schema>
schema to use
| Property | Value |
|---|---|
| Type | string |
| Required | Yes |
--table <table>
table to use
| Property | Value |
|---|---|
| Type | string |
| Required | Yes |