DataRobotPredict Syntax | Vantage BYOM - DataRobotPredict - Teradata Vantage

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Vantage
Release Number
5.0
Published
October 2023
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274
The Vantage BYOM DataRobotPredict function does not support the DataRobot explanations feature.

When ModelTable Contains Only One Model

SELECT * FROM [schema.]DataRobotPredict(
ON table|view|query as InputTable
ON { table | view | (query) } as ModelTable DIMENSION
USING
Accumulate('column'|'columns'|'*')
[ ModelOutputFields('modelOutputField'|'modelOutputFields')  ]
[ OverwriteCachedModel('cached_model_name'|'*'|'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0')]
[ IsDebug({'true'|'false'}) ]
) as alias ;

When ModelTable Contains More than One Model

SELECT * FROM [schema.]DataRobotPredict(
ON table|view|query as InputTable
ON { table | view | (query) } WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION
USING
Accumulate('column'|'columns'|'*')
[ ModelOutputFields('modelOutputField'|'modelOutputFields')  ]
[ OverwriteCachedModel('cached_model_name'|'*'|'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0')]
[ IsDebug({'true'|'false'}) ]
) as alias ;