Track Deletion with combined index

Somdeep Niyogi (external) 1 Reputation point
2022-07-12T10:25:28.247+00:00

Hi All,

I have a combined index that crawls data from Azure SQL and Blob and are mapped based a common column.

The mapped blob document is optional.

When there is no blob document the search indexer indexes the respective SQL row setting the content propertyas null and if the document is available the content property shows correct data.

I have enabled BLOB deletion tracking and the issue comes when a blob document is deleted. The deletion policy triggers and also removes the mapped SQL row values from index.

I was expecting that the content property will be set to null, but the deletion policy also removes the mapped SQL row values from index.

What am I doing wrong? Kindly help.

Thanks a lot in advance..

BR

Azure SQL Database
Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,173 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ajkuma 27,946 Reputation points Microsoft Employee
    2022-07-14T16:01:34.403+00:00

    @somdeep guha niyogi ,

    The behavior you are seeing is by default. SQL Deletion Policy deletes full index documents based on their document Key, not specific fields. The policy doesn't have a way to know the index has values from other sources too. If there is a combined index and you would like the behavior you are looking for, you may try instead using a Logic App SQL trigger to update only specific fields with Add, update or delete documents, instead of the Deletion Policy.

    I have shared the answer posted by Gia Mondragon - MSFT (from Search product team) from your discussion thread to benefit the community.

    ---
    To benefit the community find the right answers, please do mark the post which was helpful by clicking on Accept Answer’ & ‘Up-Vote’.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.