CREATE FOREIGN SERVER | Teradata Connector | QueryGrid - CREATE FOREIGN SERVER - 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

Purpose

Creates a foreign server object and associates an import table operator and an export table operator with it.

When you create a server object, you can customize it based on its purpose. You can define multiple server objects for the same remote database, each with different characteristics needed by different users.

Syntax

CREATE FOREIGN SERVER server_name
  [ EXTERNAL SECURITY [ INVOKER | DEFINER ] TRUSTED authorization_name ]
  [ using_option ]
  [ DO IMPORT WITH operator_option [, DO EXPORT WITH operator_option ] ] [;]

Syntax Elements

using_option
USING name (
  { 'value' | scalar_subquery | using_parameter | system_variable }
)
operator_option
[ database_name. ] table_operator using_option