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

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.19
Published
July 2022
Language
English (United States)
Last Update
2022-07-28
dita:mapPath
jpf1654813554544.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
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  |       |
+--------+--------+-------+