Use OpenAI, SQL Managed Instance, Python, and VSCode to UNLOCK INSIGHTS About YOUR Data!!!
@SQLBalls walks us through a demo of how to unlock insights about your data using OPEN AI. Did you know you could read a table from an @azuresqlmanagedinstance into python and then ask questions about that data using Azure OpenAI? Well you can, we walk step by step on how to do this.
Links:
Make data more human with Azure OpenAI and Azure SQL by Valentina Alto
https://devblogs.microsoft.com/azure-sql/make-data-more-human-with-azure-openai-and-azure-sql/
SQLBalls GitHub repo with sample code
https://github.com/sqlballs/SQLScripts/tree/main/OpenAI%20Python%20SQL
PyODBC
https://pypi.org/project/pyodbc/
LLM Cannot use AzureOpenAI (error that I hit and this got me past it)
https://github.com/hwchase17/langchain/issues/3510
LangChain Documentation
https://python.langchain.com/en/latest/index.html
LangChain Azure OpenAI
https://python.langchain.com/en/latest/modules/models/llms/integrations/azure_openai_example.html
Chapters
00:00 Introduction
00:47 SQL MI – Review the Data
01:22 VS Code – Python PYODBC
01:58 Azure OpenAI – Creating a service
02:51 Azure OpenAI – Create a model
03:38 Azure OpenAI – Keys & Endpoints
03:56 VS Code – Load our Data and ask questions
04:30 Unique Movie Titles
05:23 What Movie has the largest gross?
05:42 What Movie has the largest gross take 2?
06:25 What are the Average per theater returns?
07:00 What Movie has the largest average per theater returns?
07:21 La La Land?
07:40 What Movie has the largest average per theater returns 2?
08:27 Reminders and the original blog