ONNXClassification Function | BYOM | Teradata Vantage - ONNXClassification Syntax - Teradata Vantage

Teradata Vantage™ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
7.0
Published
October 2025
ft:locale
en-US
ft:lastEdition
2025-11-07
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274

When ModelTable Contains Only One Model

SELECT * FROM [<schema>.]ONNXClassification(
    ON { table | view | (query) } [as InputTable]
    ON { table | view | (query) } [as ModelTable] DIMENSION
    ON { table | view | (query) } [as TokenizerTable] DIMENSION
USING
    Accumulate(column|columns|'*')
    ModelOutputFieldsMap(ValidOutputFieldMapping)
    OutputFormat(ValidOutputFormatsList)
    [ EncodeMaxLength(Integer) ]
    [ ShowModelProperties({'true'|'false'}) ]
    [ OverwriteCachedModel(cached_model_name|'*')]
    [ UseCache({'true'|'false'}) ]
    [ IsDebug({'true'|'false'}) ]
    [ EnableMemoryCheck({'true'|'false'}) ]
    [ SkipSpecialTokens({'true'|'false'}) ]
    [ Const_name_of_constant(value) ]
) as <alias> ;

When ModelTable Contains Multiple Models

SELECT * FROM [schema.]ONNXClassification(
    ON { table | view | (query) } [as InputTable]
    ON { table | view | (query) } [as ModelTable] DIMENSION
    ON (SELECT*FROM [table | view | {query}) WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION
USING
    Accumulate(column|columns|'*')
    ModelOutputFieldsMap(ValidOutputFieldMapping)
    OutputFormat(ValidOutputFormatsList)
    [ EncodeMaxLength(Integer) ]
    [ ShowModelProperties({'true'|'false'}) ]
    [ OverwriteCachedModel(cached_model_name|'*')]
    [ UseCache({'true'|'false'}) ]
    [ IsDebug({'true'|'false'}) ]
    [ EnableMemoryCheck({'true'|'false'}) ]
    [ SkipSpecialTokens({'true'|'false'}) ]
    [ Const_name_of_constant(value) ]
) as <alias> ;