ONNXEmbedding Syntax | Vantage BYOM - ONNXEmbeddings Syntax - Teradata Vantage

When ModelTable Contains Only One Model

SELECT * FROM [schema.]ONNXEmbeddings (
ON { table | view | (query) } as InputTable
ON { table | view | (query) } [ as ModelTable DIMENSION ] //current model
ON { table | view | (query) } as TokenizerTable DIMENSION
USING
	Accumulate(column|columns|'*')
	ModelOutputTensor(ValidOutputTensorName)
	[ EncodeMaxLength(Integer) ]
	[ ShowModelProperties({'true'|'false'}) ]
	[ OutputColumnPrefix({‘emb_’ | ‘prefix’}) ]
	[ OutputFormat('Type(Integer)') ]
	[ OverwriteCachedModel(cached_model_name|'*')]
	[ EnableMemoryCheck({'true'|'false'}) ]
) as alias ;

When ModelTable Contains Multiple Models

SELECT * FROM [schema.]ONNXEmbeddings (
ON { table | view | (query) } as InputTable
ON (SELECT * FROM [table | view | {query}) WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION
ON { table | view | (query) } as TokenizerTable DIMENSION
USING
	Accumulate(column|columns|'*')
	ModelOutputTensor(ValidOutputTensorName)
	[ EncodeMaxLength(Integer) ]
	[ ShowModelProperties({'true'|'false'}) ]
	[ OutputColumnPrefix({‘emb_’ | ‘prefix’}) ]
	[ OutputFormat('Type(Integer)') ]
	[ OverwriteCachedModel(cached_model_name|'*')]
	[ EnableMemoryCheck({'true'|'false'}) ]
) as alias ;