Realtime Functions Examples: Using dbID, filename, and tokenizerName - 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',
    '',
    '00-00-61-04',
    'bge_small_en_v1_5',
    'tokenizer_bge_small_en_v1_5'
) as jr ;
    
 *** 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',
    '',
    '',
    'sequences',
    '{"min_length": 10, "max_length": 100, "num_beams": 4, "repetition_penalty": 1.2, "length_penalty": 2.0, "num_return_sequences": 1}',
    '00-00-61-04',
    't5_small_headline_generator_fixed',
    't5_small_headline_generator_fixed_tokenizer'
) as jr ;
    
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 19 seconds.
jr
-----------------------------------------------------------------------------------------------------"Beautiful High Quality Glasses: These Classes Are Made of Heavy Thin Glass.
    
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+