Kernel Memory with Cosmos DB for NoSQL vector search.

var sql =

    $"""

    SELECT Top @topN

      x.id, x.tags, x.payload, x.embedding, x.similarityScore

    FROM (

      SELECT

        c.id, c.tags, c.payload, c.embedding,VectorDistance(c.embedding, @embedding) AS similarityScore 

      FROM

        c

    ) AS x

    WHERE x.similarityScore > @similarityScore

    ORDER BY x.similarityScore desc

    """;



var queryDefinition = new QueryDefinition(sql)

    .WithParameter("@topN", limit)

    .WithParameter("@embedding", textEmbedding.Data)

    .WithParameter("@similarityScore", minRelevance);



// Index name as cosmos container name

var feedIterator = _cosmosClient

    .GetDatabase(DatabaseName)

    .GetContainer(index)

    .GetItemQueryIterator<MemoryRecordResult>(queryDefinition)