Vector type

Use the vector type to store vectors, such as embeddings, which you can then use for vector searches.

When you define a vector column, you specify the vector dimensions.

vector columns can store pre-generated vectors, or can automatically generate vector embeddings from a string.

To use a vector column:

Create a vector column. For examples, see Create a table with a column to store vector embeddings, create a table with a column to automatically generate vector embeddings, or alter a table to add a vector column or vectorize integration.

You can define multiple vector columns to store vectors with different dimensions or from different embedding models, but you can only run a vector search on one column at a time.
Index the vector column.
Store vector data in the column. For examples, see Insert a row with vector embeddings and Insert a row and generate vector embeddings.
Use vector search on the column. For examples, see Use vector search with a search vector to find a row and Use vector search with a search string to find a row.

Was this helpful?