Getting Started with GitHub Copilot in Azure Data Studio

  • Thread starter Thread starter japhletnwamu
  • Start date Start date
J

japhletnwamu

Azure Data Studio has emerged as a modern, versatile, and user-friendly tool that is empowering data professionals to seamlessly manage, develop, and interact with data. It is a lightweight, data management and development tool that offers connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux with immediate capability to connect to Azure SQL and SQL Server.



But here is the best part! Beyond SQL, with extensions that you can install, you can connection to additional databases such as PostgreSQL, MySQL and CosmosDB. Once a database is connected, Azure Data Studio provides several tools to help you interact with that server, write queries, and ensure that the server is in good operational health.



GitHub Copilot is an AI-powered code completion tool created to assist developers by suggesting code completions and generating contextual code snippets as they write, leveraging the power of OpenAI's GPT-3 (Generative Pre-trained Transformer 3) language model. It uses machine learning algorithms and natural language processing to understand the context of the code being written. It analyzes the code in real-time, including the programming language, variable names, and function calls, and generates intelligent code suggestions.



Imagine combining both! If you are a developer who wants to get started exploring data, then GitHub Copilot on Azure Data Studio can help you get started.



Spoiler (Highlight to read)
GitHub Copilot is free for verified students and for maintainers of popular open-source projects on GitHub.
GitHub Copilot is free for verified students and for maintainers of popular open-source projects on GitHub.



Installing GitHub Copilot in Azure Data Studio

Getting started with GitHub Copilot is easy! Ensure you have Azure Data Studio version 1.44 or later installed on your machine. You must also have an active GitHub Copilot subscription. To learn more about billing for GitHub Copilot, click here. Now let’s dive right into it!




1. Head over to Azure Data Studio and select the Extensions icon in the left-side menu.



large?v=v2&px=999.pngAccessing the extensions window in Azure Data Studio



2. Search for GitHub Copilot in the “Extensions tab” and then click on Install. Within minutes, you will have your extension installed and ready to use.




large?v=v2&px=999.pngInstalling GitHub Copilot extension in Azure Data Studio



3. To be able to access GitHub Copilot within Azure Data Studio, you will be required to sign into GitHub. Click the prompt at the bottom right corner of the page to begin the process.



large?v=v2&px=999.pngCongratilations on setting up GitHub Copilot



4. Once confirmation and authorization are completed, you will see a screen in your browser like the one below. Now you are all set!



Using Copilot in Azure Data Studio

To use GitHub Copilot for Azure Data Studio, you must have an active internet connection. With GitHub Copilot, you get suggestions about your code in real-time whenever you type code in the editor. GitHub Copilot also helps suggest code when you input a natural language comment anytime in your codebase.




In this episode of Open at Microsoft, Erin Stellato a Senior Program Manager at Microsoft and Subhojit Basak a Product Manager at Microsoft share examples of how GitHub Copilot in Azure Data Studio can help make writing queries against your database easier and better.






Copilot in Azure Data Studio is a game-changer for developers worldwide. Its ability to provide intelligent code suggestions and completions significantly improves productivity, enhances code quality, and promotes a culture of learning and collaboration.



As you embark on your coding journey or navigate complex projects, leverage Copilot to streamline your development process, learn new coding techniques, and ultimately craft cleaner and more efficient code. Join the ever-evolving world of development powered by Copilot in Azure Data Studio, and witness firsthand how it transforms your coding experience, making you a more productive and proficient developer.



Additional Resources


Continue reading...
 
Back
Top