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

Teradata® Fabric - Installation and User Guide - 3.11

Product
Teradata Fabric
Release Number
3.11
Published
August 2026
ft:locale
en-US
ft:lastEdition
2026-08-15
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ezw1784752870623.ditaval
dita:id
lxg1591800469257

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  |       |
+--------+--------+-------+