azure-search-indexers-index-data-without-writing-code

azure-search-indexers-index-data-without-writing-code_1.sql

CREATE VIEW [SalesLT].[vProductAndDescriptionIndex] 
WITH SCHEMABINDING 
AS 
-- View (indexed or standard) to display products and product descriptions by language.
SELECT 
    p.[ProductID] as [id]
    ,p.[Name] 
    ,pm.[Name] AS [ProductModel] 
    ,pmx.[Culture] 
    ,pd.[Description] 
FROM [SalesLT].[Product] p 
    INNER JOIN [SalesLT].[ProductModel] pm 
    ON p.[ProductModelID] = pm.[ProductModelID] 
    INNER JOIN [SalesLT].[ProductModelProductDescription] pmx 
    ON pm.[ProductModelID] = pmx.[ProductModelID] 
    INNER JOIN [SalesLT].[ProductDescription] pd 
    ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];
GO

azure-search-indexers-index-data-without-writing-code_2.json

{
"name" : "datasource1",
"type" : "azuresql",
"credentials" : { "connectionString" : "Server=tcp:azuresearchindexer.database.windows.net,1433;Database=AzureSearchIndexer;User ID=XYZ;XYZ @A;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" },
"container" : { "name" : "[SalesLT].[vProductAndDescriptionIndex] " }
}

azure-search-indexers-index-data-without-writing-code_3.json

{ 
"name" : "indexer1",
"dataSourceName" : "datasource1",
"targetIndexName" : "index1"
}

azure-search-indexers-index-data-without-writing-code_4.json

"value": [
{
"@search.score": 1.3257511,
"id": "858",
"Name": "Half-Finger Gloves, S"
},
{
"@search.score": 1.3257511,
"id": "859",
"Name": "Half-Finger Gloves, M"
},
{
"@search.score": 1.3257511,
"id": "860",
"Name": "Half-Finger Gloves, L"
},
....