Allow indexer data source to use custom schema for SQL Azure
Today we HAVE to use dbo schema for source tables used as data sources by the search indexer. As you know, a lot of enterprises have rules against allowing objects to be created on dbo. This seems like a unnecessary requirement, and surely this could be a simple fix, right? Just let me specify whatever level of qualifier for the container name of my object in SQL Azure...
This is now available. You can specify a schema-qualified name when creating a datasource like this: “dbo.table” or “[dbo].[table]”
Your Azure Search team
Bill McCrary commented
Awesome! Our DBAs will thank you!