You can enable autonomous embedding generation on new or existing tables that you make with the CREATE TABLE or ALTER TABLE statements.

You can enable autonomous embedding generation on new or existing tables that you make with the CREATE TABLE or ALTER TABLE statements. When you do this, BigQuery maintains a column of embeddings on the table based on a source column. When you add or modify data in the source column, BigQuery automatically generates or updates the embedding column for that data.

This feature is generally available (GA).