Realtime Functions Examples: Using inputBlob and tokenizerBlob from Table - 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

ONNXEmbeddingsRT

SELECT MLDB.ONNXEmbeddingsRT(
    '{"txt": "''Beautiful  High Quality Glasses: These classes are made of heavy  thin glass. The designs are made "}',
    'ONNXEmbeddings_model1',
    '',
    '',
    'sentence_embedding',
    '',
    m.model,
    t.tokenizer
) as jr
from onnxembeddings_models m, embeddings_tokenizers t
where m.model_id='bge-small-en-v1.5' and t.tokenizer_id = 'bge-small-en-v1.5';
    
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
json report
-----------------------------------------------------------------------------------------------------
-0.015426759,0.034454353,0.049282163,-0.06816973,-0.0076620965,0.012248871,-0.013027965,0.022452591,-0.06662118,-0.054419063,-0.05914,-0.009344143,-0.021094663,0.045802377,0.0048587252,0.0121589955,0.05408056,-0.059113834,-0.057219878,0.020378124,0.09211658,-0.014405589,-0.056671213,0.05423828,0.025298437,0.027536044,0.0050703976,-0.004820542,-0.017961666,-0.13479698,-0.023520613,0.010096877,0.017185349,-0.0024731436,0.0071903532,-0.052646577,-0.042739365,0.04251248,0.0059893806,-0.044357393,-0.01915462,-0.05137878,-0.038387567,0.016339382,0.04271477,0.0051413393,0.02413592,-0.039851826,0.01842746,0.025421936,-0.05659731,-0.060019545,-0.038219213,-0.027411694,3.5299046E-5,0.03229369,0.014383083,0.0029145475,0.0268182,0.009553412,0.022094062,-0.050898746,-0.08546867,0.05312385,-0.058857888,0.023323882,-0.011029883,-0.041807313,0.0137575455,-0.026564522,0.043667153,0.0141045,0.10229289,0.034798663,0.019300926,0.01639792,-0.008683657,-0.060660128,-0.055906557,0.04440768,0.038860515,-0.105
    
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+

ONNXSeq2SeqRT

SELECT MLDB.ONNXSEQ2SEQRT(
    '{"TXT": "''Beautiful  High Quality Glasses: These classes are made of heavy  thin glass. The designs are made "}',
 'ONNXSEQ2SEQ_MODEL1',
    'DEBUG,DISABLEMEMORYCHECK',
    '',
    'SEQUENCES',
    '{"MIN_LENGTH": 10, "MAX_LENGTH": 100, "NUM_BEAMS": 4, "REPETITION_PENALTY": 1.2, "LENGTH_PENALTY": 2.0, "NUM_RETURN_SEQUENCES": 1}',
    M.MODEL,
    T.TOKENIZER
) AS JR
FROM ONNXSEQ2SEQ_MODELS M, SEQ2SEQ_TOKENIZERS T
WHERE M.MODEL_ID='T5-SMALL-HEADLINE-GENERATOR_FIXED' AND T.TOKENIZER_ID = 'T5-SMALL-HEADLINE-GENERATOR_FIXED';
    
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 14 seconds.
json report
-----------------------------------------------------------------------------------------------------
"Beautiful High Quality Glasses: These Classes Are Made of Heavy Thin Glass.
    
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+