[Wranglers] Announcing General Availability of Native Vector Type & Functions in Azure SQL

[Ali, Saqib]

Azure SQL now has a native Vector Data Type. In addition to that, following
Vector functions have been added:

VECTOR_DISTANCE: Calculates the distance between two vectors using a
specified distance metric. Supports Cosine distance, Euclidean distance and
(Negative) Dot product
VECTOR_SEARCH: Return the closest vectors to a given query vector and
distance metric using an approximate vector search algorithm.
VECTOR_NORM: Takes a vector as an input and returns the norm of the vector
(which is a measure of its length or magnitude) in a given norm type.
VECTOR_NORMALIZE: Takes a vector as an input and returns the normalized
vector, which is a vector scaled to have a length of 1 in a given norm
type. Adjusts a vector so that its length is normalized following the rules
of specified norm type.
VECTORPROPERTY: Returns specific properties of a given vector.


https://devblogs.microsoft.com/azure-sql/announcing-general-availability-of-native-vector-type-functions-in-azure-sql/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20250619/e4c6f14f/attachment.htm>