CODEWITHSUNDEEP
azureazure-sql-databaseazure-cognitive-search
Andrei Hryhoryeu
Andrei Hryhoryeu

Reputation: 33

Azure Search datasource with integrated change tracking

I'm trying to create an Azure Search datasource using SQL Integrated change tracking. My DB is SQL Azure V12. I've enabled change tracking for the target table (News) - I've checked and double checked. But still when I'm trying to create a DataSource, I get the error:

Integrated change tracking is not enabled for table 'dbo.News'.

Here are my settings:

{
    "name": "news-titles",
    "type": "azuresql",
    "credentials": { "connectionString": "..." },
    "container": { "name": "dbo.News" },
    "dataChangeDetectionPolicy": { "@odata.type": "#Microsoft.Azure.Search.SqlIntegratedChangeTrackingPolicy" }
}

Upvotes: 2

Views: 992

Answers (1)

Eugene Shvets
Eugene Shvets

Reputation: 4671

in your data source definition, try to specify the table name without the "dbo." prefix, as just "News". HTH, Eugene

Upvotes: 3

Related Questions