2.10 - show - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

The show() method can be called to view a catalog of all non-native table (permanent or temporary) created under the current Foreign Server object (does not require connection to remote). If a permanent non-native table name is passed to the show() method, then the complete CREATE TABLE statement for that non-native table is displayed.

scala> s1.show

LINK: s2h.active
+-----------+--------------+------------+
|local_table|remote_table  |is_temporary|
+-----------+--------------+------------+
|nn2        |default.test  |true        |
|default.nn1|user1.players |false       |
+-----------+--------------+------------+
scala> s1.show("default.nn1")
+----------------------------------------------------------+
|createtab_stmt                                            |
+----------------------------------------------------------+
|CREATE TABLE `default`.`nn1` (`number` INT, `name` STRING)
USING com.teradata.querygrid.qgc.spark
OPTIONS (
  `serialization.format` '1',
  `version` 'active',
  `link` 's2h',
  `table` 'user1.players'
)                                                          |
+----------------------------------------------------------+