Azure Search Azure SQL Database Integration

0
votes

I am currently trying to integrate Azure Search to my Azure SQL Database in order to enable Spatial searcing. In my index there is a field that is type of Edm.GeographyPoint. What is Sql database's column type should be?, because Geography type did not work.

Additionally, my datasource's datachange field is like this:

"dataChangeDetectionPolicy" : { "@odata.type" : "#Microsoft.Azure.Search.HighWaterMarkChangeDetectionPolicy", "highWaterMarkColumnName" : "RowLastVersion" }, "dataDeletionDetectionPolicy" : { "@odata.type" : "#Microsoft.Azure.Search.SoftDeleteColumnDeletionDetectionPolicy", "softDeleteColumnName" : "Deleted", "softDeleteMarkerValue" : "0" }

Is there anything additionally i have to do for auto indexing?, Because These are also not working.

Azure Search is a perfect api. However, there is a lack of documents that we can use.

1
sql-serverazure-sql-databaseazure-cognitive-search
Hi Arda, I work on Azure Search. Geospatial types are not currently supported for auto-indexing. Please vote for this UserVoice suggestion to help us prioritize adding this feature: feedback.azure.com/forums/263029-azure-search/suggestions/… – Eugene Shvets
Regarding your question about change detection policies, what errors are you seeing? Does your table have columns called "RowLastVersion" and "Deleted"? What is the data type of those columns? Thanks, Eugene – Eugene Shvets
Thank you for your comments. My table has columns RowLastVersion, which is Rowversion type, Deleted, which is varchar(1) type. I am not getting any error. Just, my changes in table does not affect Azure Search index. – Arda Güçlü
Hi Arda, do you have a schedule set up for the indexer? And what is the interval on that schedule? – Eugene Shvets
Yes, my indexer includes scheduler and it is set up 5 minutes – Arda Güçlü

1 Answers

1
votes

It turned out indexer schedule's startTime was set in the future. Invoking indexer using /run indexed as expected.