Query with the SQL query editor

Applies to: ✅ SQL database in Microsoft Fabric

This article describes how to use the SQL query editor in the Microsoft Fabric portal.

The SQL query editor provides support for IntelliSense, code completion, syntax highlighting, client-side parsing, and validation. You can run Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) statements.

You can also query the data in your database with multiple tools with a SQL connection string.

SQL query editor in the Fabric portal

The SQL query editor provides a text editor to write queries using T-SQL.

To access the built-in SQL query editor, create a new query using the New SQL query button. If you select the dropdown list, you can easily create T-SQL objects with code templates that populate in your SQL query window.

As you work on your SQL query, the queries are automatically saved every few seconds. A "saving" indicator appears in your query tab to indicate that your query is being saved.

View query results

Once you've written the T-SQL query, select Run to execute the query. Two tabs contain the query result set and information.

• The result set of data is displayed in the Results tab.
  • You can further search for strings within the results grid to get filtered rows matching search criteria.
  • If number of rows returned is more than 10,000 rows, the preview is limited to 10,000 rows. To view the entire result set, you can query the data with other tools using the SQL connection string.
• The Messages tab shows SQL messages returned when SQL query is run.
• The status bar indicates the query status, duration of the run and number of rows and columns returned in results.

Save as view

You can save your query as a view using the Save as view button.

Select the schema name that you have access to create views, provide name of view and verify the SQL statement before confirming creating view. When view is successfully created, it appears in the Explorer.

Download as Excel/JSON/CSV

You can download your result set as an Microsoft Excel (.xlsx) file using the download button. You can also download JSON or CSV versions of the result set data, as well as copy/paste the result set to your clipboard.

Multiple result sets

When you run multiple queries and those return multiple results, you can select results dropdown list to see individual results.

Copilot

The SQL query editor is powered by Copilot for SQL database. It is designed to accelerate database development by leveraging generative AI to simplify and automate database management and improving the efficiency of writing T-SQL queries. Copilot is contextualized to your database's schema and can generate answers catered for you.

Copilot for SQL database offers a variety of features, detailed in the Introduction to Copilot.

Before your business can start using Copilot for SQL database, you need to enable Copilot.

Keyboard shortcuts

Keyboard shortcuts provide a quick way to navigate and allow users to work more efficiently in SQL query editor. The table in this article lists all the shortcuts available in SQL query editor in the Microsoft Fabric portal:

Function	Windows Shortcut	macOS Shortcut
New SQL query	Ctrl + J	Cmd + J
Close current tab	Ctrl + Shift + F4	Cmd + Shift + F4
Search string	Ctrl + F	Cmd + F
Replace string	Ctrl + H	Cmd + H
Undo	Ctrl + Z	Cmd + Z
Redo	Ctrl + Y	Cmd + Y
Go one word left	Ctrl + Left arrow key	Cmd + Left arrow key
Go one word right	Ctrl + Right arrow key	Cmd + Right arrow key
Indent increase	Tab	Tab
Indent decrease	Shift + Tab	Shift + Tab
Comment	Ctrl + K, Ctrl + C	Cmd + K,Cmd + C
Uncomment	Ctrl + K, Ctrl + U	Cmd + K, Cmd + U
Move cursor up	↑	↑
Move cursor down	↓	↓
Select All	Ctrl + A	Cmd + A

Related Content

• Connect to your SQL database in Microsoft Fabric
• Features comparison: Azure SQL Database and SQL database in Fabric (preview)