[secure-agent-modelarmor]

[carmona-google]

The following Command gives an "postgresql error: Permission denied on the resource." error:
WITH
rows_to_update AS (
SELECT
id
FROM
products
WHERE
embedding IS NULL
LIMIT
5000 )
UPDATE
products
SET
embedding = ai.embedding('text-embedding-005', name || ' ' || category || ' ' || distribution_center || ' ' || region)::vector
FROM
rows_to_update
WHERE
products.id = rows_to_update.id
AND embedding IS null;

In order to work, ai.embedding has to be replaced by google_ml.embedding if I'm not wrong

Thanks