Support an Azure SQL Data Warehouse as a data source (with enable change tracking).
It would be useful to be able to connect a SQL DW table to an index. I did try this but it seems SQL DW does not support the ENABLE CHANGE_TRACKING option so that means I could not synch changes which is key. Also I believe Azure search needs a PK on the table to manage changes - and DW does not use primary keys. So it may need new features in SQL DW first.....
Thank you for your feedback. While it is unlikely we’ll address this suggestion in the near future, we’ll reassess based on the number of votes it receives.
One thing we will also require for your request is for Azure SQL database to support Integrated Change Tracking as seen in SQL Server.
Azure Search Product Team