DataikuPredict Syntax | Vantage BYOM - DataikuPredict Syntax - 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

When ModelTable Contains Only One Model

SELECT * FROM [schema.]DataikuPredict(
ON { table | view | (query) } [ as InputTable ]
ON { table | view | (query) } [ as ModelTable ] DIMENSION
USING
Accumulate(column|columns|'*')
	[ ModelOutputFields(modelOutputField|modelOutputFields)  ]
	[ IsDebug({'true'|'false'}) ]
	[ OverwriteCachedModel(cached_model_name|'*')]
) as alias ;

When ModelTable Contains Multiple Models

SELECT * FROM [schema.]DataikuPredict(
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)  ]
	[ IsDebug({'true'|'false'}) ]
	[ OverwriteCachedModel(cached_model_name|'*')]
) as alias ;