Azure search blob storage field mapping

Rita Prajapati 1

how can I search the datetime data from the blob storage, and show all of them as facet navigation .I am using the template github code from Azure search knowledge mining.

SnehaAgrawal-MSFT 18,366 Reputation points

2021-11-01T16:39:46.497+00:00

@Rita Prajapati Thanks for asking question! Could you please confirm which datetime do you want to use? Is this a datetime in custom metadata or datetime of the file change date?
Let us know to help you better on this.
Rita Prajapati 1 Reputation point

2021-11-01T19:18:03.513+00:00

Hi SnehaAgrawal, this is the datetimeoffset field I am trying to map in the blob index field. I have some files in the blob storage in container and those files have some datetime like 09/10/2021 or Novemver 5th 2021. I want to extract all those dates as facet

1 answer

SnehaAgrawal-MSFT 18,366 Reputation points

2021-11-02T10:21:25.67+00:00

As its mentioned here that Standard blob metadata properties can be extracted into the fields as below: The blob indexer automatically creates internal field mappings for these blob metadata properties. You still have to add the fields you want to use the index definition, but you can omit creating field mappings in the indexer.

Use metadata_storage_last_modified (Edm.DateTimeOffset) and make it filterable and facetable: last modified timestamp for the blob. Azure Cognitive Search uses this timestamp to identify changed blobs, to avoid reindexing everything after the initial indexing.

hope this helps, let us know.
Please sign in to rate this answer.
Rita Prajapati 1 Reputation point

2021-11-02T13:39:03.157+00:00

Hi SnehaAgrawal-MSFT , sorry for the confusion, I am trying to extract the datetime data inside the content in the files, not the last modified date of the files, is it possible to get the datetime information from inside the contents. like we can filter all people , organizations in content as facet , I want to be able to get all the dates in the content as facet

Thanks for you response

SnehaAgrawal-MSFT 18,366 Reputation points

2021-11-02T15:24:06.027+00:00

If the timestamp is contained in the file, you would need to create a custom skill to parse the text and output this datetime.
This set of example custom skills might help.

https://github.com/Azure-Samples/azure-search-power-skills/tree/main/Text

Let us know.

Rita Prajapati 1 Reputation point

2021-11-02T17:32:30.347+00:00

Thank you so much. let me try custom skill
Sign in to comment