Hi, Thanks for article.
In our scenario , I want to create an index from json file in lakehouse.
I have created a subfolder in lakehouse files as above used user-assigned managed identity,
Then created index and mapped Fields in json file,
Then in indexer setting mapped index and Onelake data source created,
indexed extension --> ".json"
data to extract dropdown - tried all options
parsing Mode - Json or Json lines
I tried every permutation and combination -
but when I refresh the indexer it is showing refresh success, with 1 doc , and that doc is having long encrypted name, but data as per mapped file.
We are already using many indexes from blob and Azure SQL, in our care we refresh the data of index so it is not one time load.
We want to migrate Azure SQL to Fabric SQL DB workload and as we do not support for this in AI Index , yet so we are exploring how it can be done using files in Lakehouse.