CREATE FOREIGN SERVER | Teradata Connector | QueryGrid - Usage Notes (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
  • The target platform of the foreign server object must be running and reachable when creating the foreign server object in a Teradata system.
  • You can create multiple named foreign server objects that reference the same server using the same link.
  • Foreign server object names stored in TD_SERVER_DB must be unique.
  • Name value pairs in the server area of the syntax apply to the connection to the remote platform and to both of the table operators specified in the IMPORT WITH and EXPORT WITH clauses.
  • Server options, names, and name value pairs can appear only once in the CREATE FOREIGN SERVER syntax.
  • The order of the DO IMPORT WITH and DO EXPORT WITH clauses in the CREATE SERVER syntax does not matter.
  • You must grant SELECT, INSERT, and SHOW privileges on foreign server objects to users who need to query foreign server objects.