Provide field mapping function to inject a constant value into the index
I'm creating an index which is importing data from a SQL Server Database. I would like to add a field to the index whose value is just "OK" for every document. This field does not exist in the database and we do not want to add it there.
Is it possible to add a hard-coded field to an Azure Search index which auto-populates with the given string (in this case, "OK") for all documents that get imported?
Arra J. Derderian commented
Can we get this in there!? Would be super helpful
Are you asking for a calculated field who's value is populated while the indexer runs? This could either be a constant or potentially change based on the other values in the document.
I would suggest that we will deliver a form of this with Cognitive Search custom skills, which is currently in preview: https://docs.microsoft.com/en-us/azure/search/cognitive-search-custom-skill-interface
Please take a look and let us know if this is what you are looking for.
Salma Sallem commented
Any updates for this request? Thanks