Stored Procedures, Functions, Table Operators | Teradata Connector | QueryGrid - QueryGrid Stored Procedures, Functions, and Table Operators - 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
Teradata supplies several table operators to import and export data to and from remote systems:
  • QGRemoteImport
  • QGRemoteExport
  • QGInitiatorImport
  • QGInitiatorExport
Teradata also provides the QGExecuteForeignQuery table operator to enable DDL and DCL actions on a remote system, such as the following:
  • CREATE
  • ALTER
  • DROP
  • GRANT
  • REVOKE
QGExecuteForeignQuery is invoked by ExecuteForeignSQL when the user runs a query using ExecuteForeignSQL.

These table operators are activated from DIP.

ExecuteForeignSQL is a stored procedure that provides a simple interface for the users to run basic SQL queries. ExecuteForeignSQL and an install script are provided as part of the QueryGrid connector package.