CREATE FOREIGN SERVER | Teradata Connector | QueryGrid - CREATE FOREIGN SERVER - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
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