Realtime Functions Example: Using ModelInputFieldsMap and modelBlob - 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

ONNXPredictRT

SELECT MLDB.ONNXPredictRT(
    json_compose(sepal_length,sepal_width,petal_length,petal_width),
    'ONNX_Predict_ModelRT_1',
    'debug',
    onnx_models.model,
    'float_input=[0:3]'
) as jr
FROM svm_iris where id=1
AND onnx_models.model_id = 'iris_db_dt_model';
    
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
json report
-----------------------------------------------------------------------------------------------------
{"output_probability":[{"info":{"size":3,"keyType":"STRING","valueType":"FLOAT"},"value":{"1":1.0,"2":0.0,"3":0.0},"type":"ONNX_TYPE_MAP"}],"output_label":["1"]}
    
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+