CREATE FOREIGN SERVER | Teradata Connector | QueryGrid - Usage Notes (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
  • 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.