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
B035-5991
lifecycle
previous
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