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

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