Indexing Database

Gnana Sai krishna 40 Reputation points
2023-10-27T12:36:38.2433333+00:00

Hi,
I want to Index entire database using cognitive search service and i want to fetch the data from DB using the index, my database contains nearly 18 tables for this can i create one index, datasource , indexer for the whole database or do i need to create separate index, datasource, indexer for each table, i am using free version i have limit of 3, i can create only three

Azure SQL Database
Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
811 questions
{count} votes

Accepted answer
  1. Alberto Morillo 33,331 Reputation points MVP
    2023-10-27T13:00:40.3866667+00:00

    You can use a view to consolidate data from multiple tables. Although large views aren't ideal for SQL indexer. You can also create a new table consolidating data from others that gets updated using Azure Data Factory, Change Data Capture, Change Tracking that table will exist just for ingestion into your Cognitive Search index.


0 additional answers

Sort by: Most helpful