Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
This is the documetation for the keyboard shortcuts for the SQL Query window for Fabric Warehouses:
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-query-editor#keyboard-shortcuts
I'm using Edge.
Not counting standard text cell movement keys,
These do work for me:
New SQL query | Ctrl + Q |
Close current tab | Ctrl + Shift + F4 |
Run selected SQL script | Shift +Enter |
Cancel running SQL script | Alt+Break |
These do not work for me:
Run SQL script | Ctrl + Enter |
Indent increase | Tab |
Indent decrease | Shift + Tab |
Comment | Ctrl + K, Ctrl + C |
Uncomment | Ctrl + K, Ctrl + U |
* The "tab" key inserts spaces to align to 4th column. Yes, it's a bit nit picking to say this isn't "Indent increase", but the spaces happen where the cursor is, so it doesn't always indent a line. And the indent decrease don't work since there isn't a real indent increase.
These are some random unlisted ones that work for me right now:
CTRL + U | Seems to move the cursor to the previous cursor postion |
CTRL + I (upper case i) | Engages Autocomplete at that cursor point (intellisense / CoPilot suggestions) |
CTRL + L | Highlight the entire current line. Additional presses add next line to selection. |
CTRL + SHIFT + K | Deletes the current row |
So, my question is does the documentation need to be updated? Or is work being done to restore the SQL Query window to work the way it is documented?
HI @mikeburek,
Any update on this scenario? If the shortcut keys still not works on your side, you can consider to contact to fabric team ot report the document out date and fix the shortcut key binding and usage.
Regards,
Xiaoxin Sheng
HI @mikeburek,
I suppose this issue may related to data warehouse features release, and they affected the existed shortcuts key usages. (currently, this part hasn’t been removed from the official document, so I think fabric will be fixed these at the following updates)
Regards,
Xiaoxin Sheng
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
5 | |
4 | |
2 | |
2 | |
1 |