CREATE FOREIGN SERVER | Teradata Connector | Teradata Fabric - Usage Notes (CREATE FOREIGN SERVER) - Teradata Fabric

Teradata® Fabric - Installation and User Guide - 3.11
Product
Teradata Fabric
Release Number
3.11
Published
August 2026
ft:locale
en-US
ft:lastEdition
2026-08-15
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ezw1784752870623.ditaval
dita:id
lxg1591800469257
  • 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.