

Picture by Editor | ChatGPT
# Introduction
We have all been there: scrolling endlessly by way of on-line shops, looking for that excellent merchandise. In at this time’s lightning-fast e-commerce world, we count on prompt outcomes, and that is precisely the place AI is stepping in to shake issues up.
On the coronary heart of this revolution is picture embedding. It is a fancy time period for a easy concept: letting you seek for merchandise not simply by key phrases, however by their visible similarity. Think about discovering that actual gown you noticed on social media simply by importing an image! This expertise makes on-line purchasing smarter, extra intuitive, and finally, helps companies make extra gross sales.
Able to see the way it works? We’ll present you learn how to harness the facility of BigQuery’s machine studying capabilities to construct your personal AI-driven gown search utilizing these unimaginable picture embeddings.
# The Magic of Picture Embeddings
In essence, picture embedding is the method of changing pictures into numerical representations (vectors) in a high-dimensional area. Photographs which might be semantically comparable (e.g. a blue ball robe and a navy blue gown) may have vectors which might be “nearer” to one another on this area. This enables for highly effective comparisons and searches that transcend easy metadata.
Listed here are a couple of gown pictures we are going to use on this demo to generate embeddings.
The demo will illustrate the method of making a mannequin for picture embeddings on Google Cloud.
Step one is to create a mannequin: A mannequin named image_embeddings_model
is created which is leveraging the multimodalembedding@001
endpoint in image_embedding
dataset.
CREATE OR REPLACE MODEL
`image_embedding.image_embeddings_model`
REMOTE WITH CONNECTION `[PROJECT_ID].us.llm-connection`
OPTIONS (
ENDPOINT = 'multimodalembedding@001'
);
Creating an object desk: To course of the photographs in BigQuery, we are going to create an exterior desk referred to as external_images_table
within the image_embedding
dataset which is able to reference all the photographs saved in a Google Cloud Storage bucket.
CREATE OR REPLACE EXTERNAL TABLE
`image_embedding.external_images_table`
WITH CONNECTION `[PROJECT_ID].us.llm-connection`
OPTIONS(
object_metadata="SIMPLE",
uris = ['gs://[BUCKET_NAME]/*'],
max_staleness = INTERVAL 1 DAY,
metadata_cache_mode="AUTOMATIC"
);
Producing embeddings: As soon as the mannequin and object desk are in place, we are going to generate the embeddings for the gown pictures utilizing the mannequin we created above and retailer them within the desk dress_embeddings
.
CREATE OR REPLACE TABLE `image_embedding.dress_embeddings` AS SELECT *
FROM ML.GENERATE_EMBEDDING(
MODEL `image_embedding.image_embeddings_model`,
TABLE `image_embedding.external_images_table`,
STRUCT(TRUE AS flatten_json_output,
512 AS output_dimensionality)
);
# Unleashing the Energy of Vector Search
With picture embeddings generated, we are going to use vector search to search out the gown we’re on the lookout for. Not like conventional search that depends on actual key phrase matches, vector search finds objects primarily based on the similarity of their embeddings. This implies you possibly can seek for pictures utilizing both textual content descriptions and even different pictures.
// Gown Search by way of Textual content
Performing textual content search: Right here we are going to use the VECTOR_SEARCH
perform inside BigQuery to seek for a “Blue gown” amongst all of the attire. The textual content “Blue gown” shall be transformed to a vector after which with the assistance of vector search we are going to retrieve comparable vectors.
CREATE OR REPLACE TABLE `image_embedding.image_search_via_text` AS
SELECT base.uri AS image_link, distance
FROM
VECTOR_SEARCH(
TABLE `image_embedding.dress_embeddings`,
'ml_generate_embedding_result',
(
SELECT ml_generate_embedding_result AS embedding_col
FROM ML.GENERATE_EMBEDDING
(
MODEL`image_embedding.image_embeddings_model` ,
(
SELECT "Blue gown" AS content material
),
STRUCT
(
TRUE AS flatten_json_output,
512 AS output_dimensionality
)
)
),
top_k => 5
)
ORDER BY distance ASC;
SELECT * FROM `image_embedding.image_search_via_text`;
Outcomes: The question outcomes will present an image_link
and a distance for every outcome. You possibly can see the outcomes you’ll get hold of will provide you with the closest match regarding the search question and the attire out there.
// Gown Search by way of Picture
Now, we are going to look into how we will use a picture to search out comparable pictures. Let’s attempt to discover a gown that appears just like the beneath picture:


Exterior desk for check picture: We should retailer the check picture within the Google Cloud Storage Bucket and create an exterior desk external_images_test_table
, to retailer the check picture used for the search.
CREATE OR REPLACE EXTERNAL TABLE
`image_embedding.external_images_test_table`
WITH CONNECTION `[PROJECT_ID].us.llm-connection`
OPTIONS(
object_metadata="SIMPLE",
uris = ['gs://[BUCKET_NAME]/test-image-for-dress/*'],
max_staleness = INTERVAL 1 DAY,
metadata_cache_mode="AUTOMATIC"
);
Generate embeddings for check picture: Now, we are going to generate the embedding for this single check picture utilizing ML.GENERATE_EMBEDDING
perform.
CREATE OR REPLACE TABLE `image_embedding.test_dress_embeddings` AS
SELECT *
FROM ML.GENERATE_EMBEDDING
(
MODEL `image_embedding.image_embeddings_model`,
TABLE `image_embedding.external_images_test_table`, STRUCT(TRUE AS flatten_json_output,
512 AS output_dimensionality
)
);
Vector search with picture embedding: Lastly, the embedding of the check picture shall be used to carry out a vector search in opposition to the image_embedding.dress_embeddings
desk. The ml_generate_embedding_result
from image_embedding.test_dress_embeddings
shall be used because the question embedding.
SELECT base.uri AS image_link, distance
FROM
VECTOR_SEARCH(
TABLE `image_embedding.dress_embeddings`,
'ml_generate_embedding_result',
(
SELECT * FROM `image_embedding.test_dress_embeddings`
),
top_k => 5,
distance_type => 'COSINE',
choices => '{"use_brute_force":true}'
);
Outcomes: The question outcomes for the picture search confirmed probably the most visually comparable attire. The highest outcome was white-dress
with a distance of 0.2243 , adopted by sky-blue-dress
with a distance of 0.3645 , and polka-dot-dress
with a distance of 0.3828.
These outcomes clearly reveal the power to search out visually comparable objects primarily based on an enter picture.
// The Impression
This demonstration successfully illustrates how picture embeddings and vector search on Google Cloud can revolutionize how we work together with visible knowledge. From e-commerce platforms enabling “store comparable” options to content material administration programs providing clever visible asset discovery, the purposes are huge. By reworking pictures into searchable vectors, these applied sciences unlock a brand new dimension of search, making it extra intuitive, highly effective, and visually clever.
These outcomes may be introduced to the consumer, enabling them to search out the specified gown rapidly.
# Advantages of AI Gown Search
- Enhanced Consumer Expertise: Visible search gives a extra intuitive and environment friendly approach for customers to search out what they’re on the lookout for
- Improved Accuracy: Picture embeddings allow search primarily based on visible similarity, delivering extra related outcomes than conventional keyword-based search
- Elevated Gross sales: By making it simpler for purchasers to search out the merchandise they need, AI gown search can increase conversions and drive income
# Past Gown Search
By combining the facility of picture embeddings with BigQuery’s sturdy knowledge processing capabilities, you possibly can create modern AI-driven options that remodel the way in which we work together with visible content material. From e-commerce to content material moderation, the facility of picture embeddings and BigQuery extends past gown search.
Listed here are another potential purposes:
- E-commerce: Product suggestions, visible seek for different product classes
- Trend Design: Development evaluation, design inspiration
- Content material Moderation: Figuring out inappropriate content material
- Copyright Infringement Detection: Discovering visually comparable pictures to guard mental property
Be taught extra about embeddings on BigQuery right here and vector search right here.
Nivedita Kumari is a seasoned Information Analytics and AI Skilled with over 10 years of expertise. In her present position, as a Information Analytics Buyer Engineer at Google she consistently engages with C stage executives and helps them architect knowledge options and guides them on finest follow to construct Information and Machine studying options on Google Cloud. Nivedita has executed her Masters in Know-how Administration with a deal with Information Analytics from the College of Illinois at Urbana-Champaign. She desires to democratize machine studying and AI, breaking down the technical limitations so everybody may be a part of this transformative expertise. She shares her information and expertise with the developer neighborhood by creating tutorials, guides, opinion items, and coding demonstrations.
Join with Nivedita on LinkedIn.


Picture by Editor | ChatGPT
# Introduction
We have all been there: scrolling endlessly by way of on-line shops, looking for that excellent merchandise. In at this time’s lightning-fast e-commerce world, we count on prompt outcomes, and that is precisely the place AI is stepping in to shake issues up.
On the coronary heart of this revolution is picture embedding. It is a fancy time period for a easy concept: letting you seek for merchandise not simply by key phrases, however by their visible similarity. Think about discovering that actual gown you noticed on social media simply by importing an image! This expertise makes on-line purchasing smarter, extra intuitive, and finally, helps companies make extra gross sales.
Able to see the way it works? We’ll present you learn how to harness the facility of BigQuery’s machine studying capabilities to construct your personal AI-driven gown search utilizing these unimaginable picture embeddings.
# The Magic of Picture Embeddings
In essence, picture embedding is the method of changing pictures into numerical representations (vectors) in a high-dimensional area. Photographs which might be semantically comparable (e.g. a blue ball robe and a navy blue gown) may have vectors which might be “nearer” to one another on this area. This enables for highly effective comparisons and searches that transcend easy metadata.
Listed here are a couple of gown pictures we are going to use on this demo to generate embeddings.
The demo will illustrate the method of making a mannequin for picture embeddings on Google Cloud.
Step one is to create a mannequin: A mannequin named image_embeddings_model
is created which is leveraging the multimodalembedding@001
endpoint in image_embedding
dataset.
CREATE OR REPLACE MODEL
`image_embedding.image_embeddings_model`
REMOTE WITH CONNECTION `[PROJECT_ID].us.llm-connection`
OPTIONS (
ENDPOINT = 'multimodalembedding@001'
);
Creating an object desk: To course of the photographs in BigQuery, we are going to create an exterior desk referred to as external_images_table
within the image_embedding
dataset which is able to reference all the photographs saved in a Google Cloud Storage bucket.
CREATE OR REPLACE EXTERNAL TABLE
`image_embedding.external_images_table`
WITH CONNECTION `[PROJECT_ID].us.llm-connection`
OPTIONS(
object_metadata="SIMPLE",
uris = ['gs://[BUCKET_NAME]/*'],
max_staleness = INTERVAL 1 DAY,
metadata_cache_mode="AUTOMATIC"
);
Producing embeddings: As soon as the mannequin and object desk are in place, we are going to generate the embeddings for the gown pictures utilizing the mannequin we created above and retailer them within the desk dress_embeddings
.
CREATE OR REPLACE TABLE `image_embedding.dress_embeddings` AS SELECT *
FROM ML.GENERATE_EMBEDDING(
MODEL `image_embedding.image_embeddings_model`,
TABLE `image_embedding.external_images_table`,
STRUCT(TRUE AS flatten_json_output,
512 AS output_dimensionality)
);
# Unleashing the Energy of Vector Search
With picture embeddings generated, we are going to use vector search to search out the gown we’re on the lookout for. Not like conventional search that depends on actual key phrase matches, vector search finds objects primarily based on the similarity of their embeddings. This implies you possibly can seek for pictures utilizing both textual content descriptions and even different pictures.
// Gown Search by way of Textual content
Performing textual content search: Right here we are going to use the VECTOR_SEARCH
perform inside BigQuery to seek for a “Blue gown” amongst all of the attire. The textual content “Blue gown” shall be transformed to a vector after which with the assistance of vector search we are going to retrieve comparable vectors.
CREATE OR REPLACE TABLE `image_embedding.image_search_via_text` AS
SELECT base.uri AS image_link, distance
FROM
VECTOR_SEARCH(
TABLE `image_embedding.dress_embeddings`,
'ml_generate_embedding_result',
(
SELECT ml_generate_embedding_result AS embedding_col
FROM ML.GENERATE_EMBEDDING
(
MODEL`image_embedding.image_embeddings_model` ,
(
SELECT "Blue gown" AS content material
),
STRUCT
(
TRUE AS flatten_json_output,
512 AS output_dimensionality
)
)
),
top_k => 5
)
ORDER BY distance ASC;
SELECT * FROM `image_embedding.image_search_via_text`;
Outcomes: The question outcomes will present an image_link
and a distance for every outcome. You possibly can see the outcomes you’ll get hold of will provide you with the closest match regarding the search question and the attire out there.
// Gown Search by way of Picture
Now, we are going to look into how we will use a picture to search out comparable pictures. Let’s attempt to discover a gown that appears just like the beneath picture:


Exterior desk for check picture: We should retailer the check picture within the Google Cloud Storage Bucket and create an exterior desk external_images_test_table
, to retailer the check picture used for the search.
CREATE OR REPLACE EXTERNAL TABLE
`image_embedding.external_images_test_table`
WITH CONNECTION `[PROJECT_ID].us.llm-connection`
OPTIONS(
object_metadata="SIMPLE",
uris = ['gs://[BUCKET_NAME]/test-image-for-dress/*'],
max_staleness = INTERVAL 1 DAY,
metadata_cache_mode="AUTOMATIC"
);
Generate embeddings for check picture: Now, we are going to generate the embedding for this single check picture utilizing ML.GENERATE_EMBEDDING
perform.
CREATE OR REPLACE TABLE `image_embedding.test_dress_embeddings` AS
SELECT *
FROM ML.GENERATE_EMBEDDING
(
MODEL `image_embedding.image_embeddings_model`,
TABLE `image_embedding.external_images_test_table`, STRUCT(TRUE AS flatten_json_output,
512 AS output_dimensionality
)
);
Vector search with picture embedding: Lastly, the embedding of the check picture shall be used to carry out a vector search in opposition to the image_embedding.dress_embeddings
desk. The ml_generate_embedding_result
from image_embedding.test_dress_embeddings
shall be used because the question embedding.
SELECT base.uri AS image_link, distance
FROM
VECTOR_SEARCH(
TABLE `image_embedding.dress_embeddings`,
'ml_generate_embedding_result',
(
SELECT * FROM `image_embedding.test_dress_embeddings`
),
top_k => 5,
distance_type => 'COSINE',
choices => '{"use_brute_force":true}'
);
Outcomes: The question outcomes for the picture search confirmed probably the most visually comparable attire. The highest outcome was white-dress
with a distance of 0.2243 , adopted by sky-blue-dress
with a distance of 0.3645 , and polka-dot-dress
with a distance of 0.3828.
These outcomes clearly reveal the power to search out visually comparable objects primarily based on an enter picture.
// The Impression
This demonstration successfully illustrates how picture embeddings and vector search on Google Cloud can revolutionize how we work together with visible knowledge. From e-commerce platforms enabling “store comparable” options to content material administration programs providing clever visible asset discovery, the purposes are huge. By reworking pictures into searchable vectors, these applied sciences unlock a brand new dimension of search, making it extra intuitive, highly effective, and visually clever.
These outcomes may be introduced to the consumer, enabling them to search out the specified gown rapidly.
# Advantages of AI Gown Search
- Enhanced Consumer Expertise: Visible search gives a extra intuitive and environment friendly approach for customers to search out what they’re on the lookout for
- Improved Accuracy: Picture embeddings allow search primarily based on visible similarity, delivering extra related outcomes than conventional keyword-based search
- Elevated Gross sales: By making it simpler for purchasers to search out the merchandise they need, AI gown search can increase conversions and drive income
# Past Gown Search
By combining the facility of picture embeddings with BigQuery’s sturdy knowledge processing capabilities, you possibly can create modern AI-driven options that remodel the way in which we work together with visible content material. From e-commerce to content material moderation, the facility of picture embeddings and BigQuery extends past gown search.
Listed here are another potential purposes:
- E-commerce: Product suggestions, visible seek for different product classes
- Trend Design: Development evaluation, design inspiration
- Content material Moderation: Figuring out inappropriate content material
- Copyright Infringement Detection: Discovering visually comparable pictures to guard mental property
Be taught extra about embeddings on BigQuery right here and vector search right here.
Nivedita Kumari is a seasoned Information Analytics and AI Skilled with over 10 years of expertise. In her present position, as a Information Analytics Buyer Engineer at Google she consistently engages with C stage executives and helps them architect knowledge options and guides them on finest follow to construct Information and Machine studying options on Google Cloud. Nivedita has executed her Masters in Know-how Administration with a deal with Information Analytics from the College of Illinois at Urbana-Champaign. She desires to democratize machine studying and AI, breaking down the technical limitations so everybody may be a part of this transformative expertise. She shares her information and expertise with the developer neighborhood by creating tutorials, guides, opinion items, and coding demonstrations.
Join with Nivedita on LinkedIn.