Tour the Query Editor in SQL database in Microsoft Fabric
At Ignite this year (Nov 2024), Microsoft Fabric announced the public preview of SQL database in Fabric – Announcing SQL database in Microsoft Fabric Public Preview | Microsoft Fabric Blog | Microsoft Fabric. In this post, we will dive into the query editor in SQL database in Fabric, a powerful tool that is designed to provide a lightweight, user-friendly, and integrated environment for object explorations, writing SQL queries, and monitoring and optimizing database performance.
Whether you’re a seasoned data professional or a developer new to SQL, the query editor offers features that cater to all skill levels. It provides various low-code/no-code features that simplify your development workflows, enhances productivity, fosters collaboration, ensuring accurate and efficient database interactions. Additionally, it seamlessly integrates with other Fabric workloads, allowing you to maximize the benefits of the integrated Fabric ecosystem. Learn more at Query with the SQL Editor – Microsoft Fabric | Microsoft Learn.
Key Features of the Query Editor
- Intuitive Interface for Query Editing: The query editor provides a user-friendly interface designed to streamline SQL query writing. Features like syntax highlighting, Copilot code suggestions, and error detection help you compose queries faster and with greater accuracy.
- Comprehensive Object Explorer: Explore your database schema, preview data, run quick scripts using the Object Explorer. This feature is particularly useful for understanding the context of queries and verifying results. Additionally, the shortcuts feature will soon be available, allowing direct connection to and interaction with any data sources in OneLake from the SQL database editor.
- Powerful AI Assistance: Improve query accuracy and writing efficiency with Copilot’s inline code completion and quick actions, such as “Fix query error” and “Explain the code.” You can also use the Copilot chat pane to generate SQL code from natural language and get document-based insights in a multi-turn conversation experience. Learn more at Overview of Copilot for SQL database (preview) – Microsoft Fabric | Microsoft Learn
- Seamless Integrations for Data Ingestions, GraphQL API, SQL Client Tools: Quickly ingest data using Fabric Dataflow Gen2 and Data Pipelines (1) or create GraphQL APIs (3) with a few clicks from the editor. You can also open a connection in preferred client tools, such as VS Code or SSMS (2).
- Actionable Insights from Performance Dashboard: Optimize your database and query performance using the built-in performance dashboard. It provides alerts to help you and your team identify performance bottlenecks early on and gain actionable insights to solve it on your own. Learn more at Performance Dashboard for SQL database – Microsoft Fabric | Microsoft Learn.
- Simplified Security and Database-level Roles Management: Manage database-level roles and security with ease within the editor. This modern approach lets you define custom user roles and manage memberships tailored to your specific data access needs via a GUI—without relying solely on writing T-SQL commands. Learn more at Configure granular access control for a SQL database – Microsoft Fabric | Microsoft Learn.
- Reporting and Analytics using the SQL Analytics Endpoint: Use the drop-down button in the top-right corner to navigate to the SQL analytics endpoint, where you can access a read-only data copy in your OneLake. Here, you can run reporting queries without worrying about impacting production, write cross-database queries, and create PowerBI reports or visualizations.
Getting Started with the Query Editor
To use the query editor, start by opening a new SQL database within your workspace. The landing page offers quick-start options, such as sample data and T-SQL templates. For additional guidance, refer to the Getting Started documentation, where you’ll find detailed steps to load data into your SQL database or begin developing efficiently.
Help Us Improve the Product by Submitting your Feedback
Click the feedback button in the ribbon to share your experiences or offer suggestions. We closely review all submissions and highly value your input, which plays a key role in shaping our roadmap and priorities. Alternatively, visit the Fabric community forums to join discussions, share feedback, and contribute and vote for product improvement ideas. Stay tuned – our release plans will be made public in early 2025.
