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.
1,339 questions
Challenges Querying SQL Database with Azure AI Services
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kushagra Sharma
90
Reputation points
Hey there!
I'm having trouble with Azure AI Services. I'm trying to connect my SQL database to Azure AI Search, but I'm struggling to get the right info from it using Azure's OpenAI Playground (Chatbot).
Database Schema - S.no | Dist_Id | Dist_Name | Sales_Revenue | Quantity
now when i am trying to querying the database using Azure openai playground i am not able to get the answers from that -
Here's what I need:
- Total number of records in the database
- Total sales of a specific distributor ("X")
Any ideas on how to make this work? Thanks!
Azure AI Search
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
4,081 questions
Azure AI services
Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
3,602 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 55.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ajkuma 28,036 Reputation points Microsoft Employee Moderator2024-04-23T08:16:27.36+00:00 From AI Search standpoint, you could index data from Azure SQL in Azure AI Search. Are you referring to this article 'Chat with your data in Azure SQL Database' for the steps? Just to clarify, does it (query/index) work as expected outside of Chat Playground?
We have also added additional tags to receive insights from the targetted audience/SMEs.
-
Kushagra Sharma 90 Reputation points
2024-04-23T09:03:22.7266667+00:00 Hello Pal,
Actually Azure AI Search functions smoothly, the challenge arises when integrating it with OpenAI to extract [analytical] insights from SQL data. The question is whether it's appropriate to leverage this combination to perform NLP operations on analytical data.For instance, storing textual data in SQL with columns like {Sno., Question, and Answer} allows seamless integration with Azure AI Search. However, when dealing with analytical data such as:
- Top 5 distributors by Sales Revenue
- Total Sales of Distributor <Distributor_Name>
This approach doesn't yield the desired results.
-
romungi-MSFT 48,906 Reputation points Microsoft Employee Moderator2024-04-23T13:36:37.07+00:00 @Kushagra Sharma I think the support for sql data as a data source or data type is not there yet. You probably have to use langchain library for this approach to get more reliable results to queries that you have mentioned above. See this blog which details a similar problem to get results for a test table.
Sign in to comment
Sign in to answer