MLeapPredict Syntax | Vantage BYOM - MLeapPredict Syntax - Teradata Vantage

Teradata Vantage™ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
February 2026
ft:locale
en-US
ft:lastEdition
2026-02-18
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274

When ModelTable Contains Only One Model

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

When ModelTable Contains Multiple Models

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