fail to create image embedding on bigquery standard table with uri links

[tomerbenmoshe]

try to create an image embedding on standard bigquery table that has uri column. fail on error: Invalid table-valued function ML.GENERATE_EMBEDDING ML.GENERATE_EMBEDDING with endpoint projects/shoeshoe/locations/us-central1/publishers/google/models/multimodalembedding@001 expects the 2nd argument to contain uri and content_type column if input table is an object table.  

The SQL is :

SELECT

  ml_generate_embedding_result.embedding

FROM

  ML.GENERATE_EMBEDDING(

    MODEL `shoeshoe.shoe_central1.image_embedding_model_central1`,

    (SELECT STRUCT("https://example.com/some_image.jpg" AS uri)) -- This subquery creates a single-row table

  ) AS ml_generate_embedding_result;