Azure AI Search
How Azure AI Search indexes Azure SQL data to enable fast refugee document and member lookup.
Overview
Azure AI Search maintains a synchronized index over the data stored in Azure SQL. Rather than querying the database directly for search operations, the platform uses this index to provide fast, flexible lookup across refugee records and documents.
How It Works
The indexer reads from Azure SQL and creates a shadow clone — an optimized, searchable copy of the data. This index supports full-text search, fuzzy matching, and filtered queries without putting load on the primary database.
Trigger
The indexing process is currently triggered manually. When run, it synchronizes the latest state of Azure SQL into the search index.
What Is Indexed
The index covers the document and family member tables, enabling search across:
- Refugee family members
- Master Card records
- Red Cross Card records