Search code examples
azureazure-cognitive-search

Azure Search, Is there a way to add Query when importing from SQL

When Importing data to an Index in Azure Search, from SQL (progrematically not through the interface), Is there a way to add Query to filter the data come from the SQL table ?

Solution

  • Looking at the REST API documentation for Create Data Source, as of today it is not possible to define a query to filter the data that populates an index.

    However I read somewhere that you can create a View and use that as the data source for populating the index. However when using a view, you will not be able to use SQL Integrated change tracking for change / deletion detection. However, you will still be able to use High Water Mark change detection and Soft Delete Column deletion detection.

    Also, please vote for this UserVoice suggestion to request adding support for query parameter.