@Bernard Brown You can still use Change Tracking for a view indirectly by creating a stored procedure that selects data from the view and returns it to Azure AI Search. You can then use the stored procedure as the data source for Azure AI Search and enable Change Tracking for the underlying tables. Here are the steps to create a stored procedure that selects data from the view and returns it to Azure AI Search:
- Open SQL Server Management Studio and connect to your database.
- Create a new stored procedure using the following syntax:
CREATE PROCEDURE [dbo].[MyViewData]
SET NOCOUNT ON;
SELECT * FROM MyView;
MyView with the name of your view.
- Save the stored procedure and execute it to make sure it returns the expected data.
- In the Azure Portal, go to your Azure AI Search service and create a new data source.
- Select "SQL" as the data source type and enter the connection string for your database.
- Enter the name of the stored procedure you created in step 2 as the table or view name.
- Enable Change Tracking for the underlying tables by following the instructions in the Azure Advisor document titled "View Azure Advisor recommendations that matter to you".
Once you have completed these steps, you should be able to use Track Changes for your Azure AI Search data source.