Dears
i’m trying to implement this tutorial
BigQuery vector search and embedding generation
From Google Cloud Tech channel on Youtube.
when i’m trying to execuate this query it’s give this error
Invalid table-valued function ML.GENERATE_EMBEDDING
ML.GENERATE_EMBEDDING expects the 2nd argument to contain a column
named content of type STRING. at [2:8]
this is the query
create or replace table `my_project_ID.my_dataset_ID.image_embeddings` as (
select *,
regexp_extract(uri,r'[^/]+$') as obj_name,
regexp_replace(regexp_extract(uri,r'[^/]+$'),r'.jpg$','') as sku_id,
'' as prodect_name
from ML.GENERATE_EMBEDDING(
MODEL `my_project_ID.my_dataset_ID.embedding_model`,
TABLE `my_dataset_ID.image_object_table`
)
);