Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja platforme Fabric, platforme Power BI i jezika SQL. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasOvaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
Applies to: ✅ Warehouse in Microsoft Fabric
Copilot for Data Warehouse provides intelligent autocomplete-style T-SQL code suggestions to simplify your coding experience.
As you start writing T-SQL code or comments in the editor, Copilot for Data Warehouse leverages your warehouse schema and query tab context to complement the existing IntelliSense with inline code suggestions. The completions can come in varied lengths - sometimes the completion of the current line, and sometimes a whole new block of code. The code completions support all types of T-SQL queries: data definition language (DDL), data query language (DQL), and data manipulation language (DML). You can accept all or part of a suggestion or keep typing to ignore the suggestions. It can also generate alternative suggestions for you to pick.
Code completion enhances your productivity and workflow in Copilot for Data Warehouse by reducing the cognitive load of writing T-SQL code. It accelerates code writing, prevents syntax errors and typos, and improves code quality. It provides helpful, context-rich suggestions directly within the query editor. Whether you're new to or experienced with SQL, code completion helps you save time and energy with writing SQL code, and focus on designing, optimizing, and testing your warehouse.
--
) at the beginning of the query and Copilot will generate the corresponding query.Verify the Show Copilot completions setting in enabled in your warehouse settings.
Start writing your query in the SQL query editor within the warehouse. As you type, Copilot will provide real-time code suggestions and completions of your query by presenting a dimmed ghost text.
You can then accept the suggestion with the Tab key, or dismiss it. If you do not want to accept an entire suggestion from Copilot, you can use the Ctrl+Right keyboard shortcut to accept the next word of a suggestion.
Copilot can provide different suggestions for the same input. You can hover over the suggestion to preview the other options.
To help Copilot, understand the query you're writing, you can provide context about what code you expect by leaving a comment with --
. For example, you could specify which warehouse object, condition, or methods to use. Copilot can even autocomplete your comment to help you write clear and accurate comments more efficiently.
Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja platforme Fabric, platforme Power BI i jezika SQL. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasObučavanje
Put učenja
Get started with Copilot for Microsoft Power Platform - Training
Microsoft Copilot for Microsoft Power Platform helps makers of all skill levels accelerate the creation of Power Apps, Power Automate flows, Power Pages and Dataverse tables used by the apps and services. Understanding how to best plan and use Copilot is essential for success.
Certifikacija
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a Fabric Data Engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.