From the course: Enhancing Your Productivity as a Data Scientist with Generative AI
Unlock this course with a free trial
Join today to access over 24,600 courses taught by industry experts.
Use case 5: SQL query copilot
From the course: Enhancing Your Productivity as a Data Scientist with Generative AI
Use case 5: SQL query copilot
- [Instructor] So, now that we have access to our database and also know the table schema and their relationships, let's actually start with our first Copilot. Remember, a Copilot is also an LM solution, but, in this case, it's more integrated into our workflow. That means, we are now not going to copy-paste stuff into ChatGPT, but, instead, we are in integrating generative AI capabilities directly into our workflow. What we're going to do now is to build a little SQL query assistant. This assistant will take a natural language query from us and then return the SQL code that needs to be written to pull the required information from the database we provide. Now, make sure you are in branch O2_06b. If you're still in Codespaces, you can switch to branch by clicking here. Now, I'm going to switch over to branch O2_06e to walk you through the end result. But if you are following along, feel free to stay in the O2_06b branch and just run the notebook from there. Scroll down, until you see…
Contents
-
-
-
-
(Locked)
Overview: Business and data understanding with GenAI5m 1s
-
Use case 1: SMART problem statements assistant5m 28s
-
Use case 2: Issue tree builder assistant5m 16s
-
(Locked)
Use case 3: Business requirements assistant5m 52s
-
(Locked)
Use case 4: Data dictionary assistant5m 46s
-
(Locked)
Use case 5: SQL query copilot8m 2s
-
(Locked)
Use case 6: EDA report assistant6m 38s
-
(Locked)
-
-
-
-
-
-