Hello,
When you add your SQL database to Azure Search, the service indexes your data. This index acts as the source from which the AI model retrieves information to answer queries. The quality and structure of this index significantly influence the model's performance.
When you use a GPT model in the Azure AI chatbot, the model generates responses based on the indexed data it can access.
AI models, especially those like GPT, may not be inherently designed for specific analytical tasks such as counting the number of open tickets. Their strength lies in natural language understanding and response generation, rather than performing database-like count operations.
In order to improve the accuracy ensure that your data is indexed in a way that makes it easily retrievable and understandable by the AI model. This might involve structuring the data or metadata in a certain way.
Also try to modify how your queries are made to ensure it retrieves and uses the most relevant data from your indexes.
For specific tasks like counting or categorizing, consider using AI solutions that are tailored for analytical operations, possibly in combination with the GPT model.
Hope this helps
Regards
If you found this answer useful, please consider marking it as 'Accepted.' This helps other users easily find and benefit from this information