At //Build 2024 earlier this year, we released the public preview of Copilot for Data Warehouse - Announcing the Public Preview of Copilot for Data Warehouse in Microsoft Fabric | Microsoft Fabric B.... In this previous announcement, you can find a deep dive of the capabilities offered as part of Copilot for Data Warehouse.
Following this, we’re happy to announce new updates regarding Copilot for Data Warehouse! First, we'll recap current capabilities and then highlight what’s new and on the horizon.
What is Copilot for Data Warehouse?
Copilot for Data Warehouse is the ultimate paired programmer, and productivity booster for any skill level developer – from data professionals to analysts. It is designed to accelerate warehouse development by leveraging generative AI to simplify and automate Data Warehouse creation, analysis, and management. Copilot is contextualized to your warehouse’s schema and generates answers catered to you.
Getting Started?
As long as Copilot in Fabric is enabled for your organization, you can get started with Copilot for Data Warehouse immediately. Copilot for Data Warehouse is seamlessly integrated across the Fabric Warehouse query editor.
You can start working with Copilot for Data Warehouse in the following areas:
Code Completions:
Start writing T-SQL in the SQL query editor and Copilot will automatically generate a code suggestion to help complete your query. You can optionally leave a comment in natural language to provide context of the query. The Tab key accepts the code suggestion or simply keep typing to ignore the suggestion.
Quick Actions:
In the ribbon of the SQL query editor, the Fix and Explain buttons are Copilot quick actions. Highlight a SQL query of your choice and select one of the quick action buttons to perform the selected action on your query.
Explain: Copilot can provide natural language explanations of your SQL query in an inline comments format.
Fix: Copilot can fix errors in your code as error messages arise. Error scenarios can include incorrect/unsupported T-SQL code, wrong spellings, and more. Copilot will also provide comments that explain the changes and suggest SQL best practices.
Chat Pane *coming soon*:
Use the chat pane to ask questions about your warehouse to Copilot through natural language.
Natural Language to SQL: Ask Copilot a question about your warehouse data and receive a generated SQL query catered to your warehouse schema.
Q&A: Ask Copilot a question about your warehouse and receive a docs-based answer and pointers to official documentation.
Brainstorm: Use Copilot to help you brainstorm relevant trends or patterns to analyze within your data.
What's New?
So, what's new with this update?
- Enabled by default: If Copilot in Fabric is enabled for the tenant and capacity, Copilot for Data Warehouse will also be available in all respective warehouse artifacts - no more special signups required!
- Metrics Usage: Copilot for Data Warehouse now reports usage & consumption in the capacity metrics app
- New Look & Feel: Copilot for Data Warehouse now has updated icons, button names, and new features in the chat like clearing conversation.
- Copilot Completions toggle: You can now disable Copilot completions for each warehouse artifact. Within the warehouse settings, there is a new section for “Copilot” where Copilot completions within the SQL query editor can be enabled or disabled.
What's Coming Soon?
- Copilot for SQL analytics endpoint: While you can already use Copilot with the SQL analytics endpoint from any warehouse, Copilot will soon be natively enabled in the SQL analytics endpoint as well.
- Quality improvements: We are continuously investing in quality and accuracy improvements for Copilot generated SQL queries.
- Schemas/tables selection: Copilot will soon offer the capability to select which schemas/tables are used and analyzed when generating SQL queries.
- AI Skills Integration: Create Q&A systems used internally in the apps you love like Office and externally as well.
This is just the tip of the iceberg! Stay tuned to the blog for more updates in this area.
Next Steps:
Get started with Copilot for Data Warehouse: Copilot for Data Warehouse (preview) - Microsoft Fabric | Microsoft Learn
Check out our Data Warehouse roadmap: What's new and planned for Synapse Data Warehouse in Microsoft Fabric - Microsoft Fabric | Microsoft...
Have a feature request? Post your thoughts to Ideas (microsoft.com).
Join us in this exciting journey to make data more accessible, understandable, and actionable for everyone in your organization. Thanks for reading!