Use Azure AI search as Data source for Chatbot

Question

I am creating a Chatbot to answer our private data which is stored in Azure SQL Database. I would like to be able to get answers from data in the database in the chatbot.

I have used AI search as Data source for the chat bot. Data from Azure SQL database is imported to the AI search Index.

I want to answer questions like 'Give me list of data of this year' and use a date field for that.

I have made the field Facetable which has given me the expected output, i.e. results based on that date field.

Alternate solution seems is vector search. But the path to implementation is not clear.

What is the correct approach to use AI search for chatbot along with Open AI do that it gives correct text based answers and accurate interval related answers.

Answer 1

@Clarion User Thanks for reaching here! It sounds like you are using Azure AI Search as a data source for your chatbot, and you want to be able to answer questions based on data in your Azure SQL Database. You have made the date field facetable, which has given you the expected output, but you are also considering using vector search for more accurate interval-related answers.

You may want to know that Vector search is an approach in information retrieval that stores numeric representations of content for search scenarios. Because the content is numeric rather than plain text, the search engine matches on vectors that are the most similar to the query, with no requirement for matching on exact terms.

This article is a high-level introduction to vectors in Azure AI Search. It also explains integration with other Azure services and covers terminology and concepts related to vector search development.

• Refer to detailed document - https://learn.microsoft.com/en-us/azure/search/vector-search-overview

Let us know, for further query here.