surface↓embedding↓embed_with_storage
Embeddingscalar · returns double[]

EMBED_WITH_STORAGE

Generate embedding and store with table/column/ID tracking

Per-row — runs once for each row.

embeddingembedding-modelspecialist-zootext

Arguments

nametypedescription
textVARCHARText to embed
model(optional)VARCHAROptional model
source_tableVARCHARSource table name
column_nameVARCHARSource column name
source_idVARCHARSource row ID

About

Generate text embeddings AND store them in lars_embeddings with table/ID tracking. SQL Usage: SELECT id, semantic_embed_with_storage(description, NULL, 'products', 'description', CAST(id AS VARCHAR)) FROM products; This stores: source_table='products', metadata={'column_name': 'description'}, source_id='1'

Nearby rabbit holes

same domain
scalar

EMBED

Generate 768-dim embedding vector from text (on-box nomic-embed-text-v1.5)

embeddingembedding-modelspecialist-zooscales-large+1
scalar

EMBED_BATCH

Batch embed rows and store in lars_embeddings

embeddingembedding-modelspecialist-zootext
scalar

EMBED_BATCH_ELASTIC

Batch embed rows and store in Elasticsearch for hybrid search

embeddingembedding-modelspecialist-zootext
scalar

EMBED_BATCH_PINECONE

Batch embed rows and store in Pinecone for vector search

embeddingembedding-modelspecialist-zooscales-large+1
scalar

EMBED_STATUS

Check embedding coverage for a table/column

embeddingembedding-modelspecialist-zootext
scalar

IMAGE_EMBED

SigLIP 2 embedding for an image (L2-normalized, shared image/text space)

embeddingembedding-modelspecialist-zooimage
Climb back to The Looking Glass