Help Foreign Schema Command | Teradata Vantage - Help Foreign Schema Command - Teradata Vantage

Machine Learning Engine User Guide

Product
Teradata Vantage
Release Number
9.02
9.2.4
9.2.3
2.3.2
1.3
Published
May 2022
Language
English (United States)
Last Update
2022-05-04
dita:mapPath
kaz1597341649653.ditamap
dita:ditavalPath
ehs1594682156756.ditaval
dita:id
B700-4004
lifecycle
previous
Product Category
Teradata Vantageā„¢
The default output of the HELP FOREIGN SCHEMA command lists all tables, views, functions, and installed files for which the user has privileges.

If listPublicFiles was enabled during ML Engine deployment, HELP FOREIGN SCHEMA "public"@coprocessor will list all tables, views, and functions for which the user has privileges and will also list all installed files on the public schema regardless of ownership.

The output of this command displays the coprocessor function names. See ML Engine Analytic Function Mapping to map your function with its coprocessor function name.

You must append @coprocessor to the schema name.

HELP FOREIGN SCHEMA "public"@coprocessor;
objectname                     objecttype      owner
------------------------------ --------------- -----------------
addoneplayer                   function        db_superuser
attribution                    function        db_superuser
burst                          function        db_superuser
ccm                            function        db_superuser
ccmmap                         function        db_superuser
ccmprepare                     function        db_superuser
ccmreduce                      function        db_superuser
changepointdetection           function        db_superuser
cmavg                          function        db_superuser
coxph                          function        db_superuser
densesvmformatconverter        function        db_superuser
densesvmmodelprinter           function        db_superuser
densesvmpredictor              function        db_superuser
densesvmtrainer                function        db_superuser
dtw                            function        db_superuser
dwt                            function        db_superuser
dwt2d                          function        db_superuser
dwtreduce                      function        db_superuser
emavg                          function        db_superuser
evaluatesentimentextractor     function        db_superuser
fft                            function        db_superuser
findnamedentity                function        db_superuser
glm                            function        db_superuser
glmpredict                     function        db_superuser
ifft                           function        db_superuser
kmeans                         function        db_superuser
sentinizer                     function        db_superuser
trainsentimentextractor        function        db_superuser