showColumns Method | Spark SQL Initiator Connector | QueryGrid - showColumns - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem

The show*() methods can be used for schema and metadata discovery queries and are equivalent to HELP FOREIGN SERVER/DATABASE/TABLE queries on the Teradata system. The showColumns method displays the schema of a target table specified by a fully-qualified name (for example: schema.table or database.schema.table).

scala> s1.showColumns("user1.players")
+--------+--------+-------+
|COL_NAME|COL_TYPE|COMMENT|
+--------+--------+-------+
|number  |int     |       |
|name    |string  |       |
+--------+--------+-------+