Warehouse T-SQL keyboard shortcuts not working

[coverturfLSH]

In the past (a month ago?) I used to be able to use keyboard shortcuts data warehouse in the web browser when writing T-SQL (CTRL+Enter to run, CTRL+/ to comment, Tab to indent). I'm using Chrome but it also didn't work in Edge.

Has anyone else experienced using keyboard shortcuts before and they are not working today?

Thanks

[coverturfLSH]

Tab to intent is now working again in Chrome as of this post

[mikeburek]

Someone was telling me the other day that tab wasn't working for them. That tab would move to the next text area instead of indenting. I assumed it was always that way. But nice to know that was just a temporary bug and it is now indenting again. It does currently work for me. But I never tried it before. (I'm using Edge)

[coverturfLSH]

It worked all the way up until I initially created this post. Then it started working again yesterday. CTRL+Enter used to be a shortcut that would run the query, but that has not started working again yet. Not sure if the distruption is caused by Microsoft or the web browsers

[mikeburek]

Thanks for posting this question and your comments. I didn't even know keyboard shortcuts were in the SQL query editor window. Cool!

[coverturfLSH]

We use DBeaver to connect to the warehouse via the SQL endpoint but you can also use SQL Server Management Studio. They offer a lot more functionality than the web version, but it was nice to be able to just run some quick queries in the web without opening the application. 

[mikeburek]

Does DBeaver have autocomplete for Fabric Warehouse objects?

SQL Server Management Studio (SSMS) does not. Azure Data Studio (ADS) does not. SSMS nor ADS have intellisense for Azure Synapse Analytics, either.

This web editor now does with Copilot.

[coverturfLSH]

If the auto complete you're referring to is something with a table alias R, you can type "R." and it will show you a list of columns available within the R table, then Yes*! Will also filter down the list if you start typing text for example "R.some" would show "R.sometext" and "R.handsome"

We use DBeaver at my company because we also connect to Redshift so it's nice being able to query either server within the same application.

*Yes meaning it works 90% of the time but randomly decides to not work sometimes.

[mikeburek]

Oh, that's awesome! Thanks for letting me know.

Yes, computer intelligence only goes so far. Ha!

[mikeburek]

I use SSMS. Which is why I never thought about looking into keyboard shortcuts for the web editor. But your post got me curious!

[v-huijiey-msft · Accepted solution]

Hi @coverturfLSH ,

In fabric's notebook, the Edge browser works fine with shortcuts.

For the time being, I've only seen you report this issue, I'll keep a close eye on the community to check if anyone else is reporting similar issues.

I have not used shortcuts in warehouse and am not sure if warehouse supports operations via shortcuts.

You mentioned that you can use shortcuts in Chrome, not Edge. As an alternative, I would suggest that you can use shortcuts in Chrome first, and if you want to run warehouse in Edge , you can run it by clicking on the run button instead of shortcuts.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[JakeTully]

+1, having the same issue.

[coverturfLSH]

Thanks Yang, I could have sworn I used shortcuts previously, but hard to go back and test now. I accepted your comment as the solution and I'll report back if shortcuts start working again.

[JakeTully]

I can confirm they used to work as well.  They stopped working a while back, and I thought it was some combination of keys I pressed that turned off the functionality, but I have no idea why it stopped working.

I'm using Chrome, and primarily used to use ctrl+enter to run queries, and ctrl+/ to comment and uncomment blocks of SQL.

Neither works now, ctrl+enter just acts like I'm just pressing enter, and makes a new line.

Super frustrating, any solution would be greatly appreciated.

[coverturfLSH]

I'm pretty sure the Copilot integration broke it. Tab came back (this was really annoying to go missing) so there's hope the rest of the shortcuts come back too. 

[arpost]

You're correct, @coverturfLSH. I noticed shortcuts have stoppped working in Edge too. I feel like this might have corresponded to when AI/Copilot was added to Fabric DW UI, though I'm not certain on that. It's very annoying as the Command Palette doesn't work either.

[coverturfLSH]

I didn't even know about the command pilot but I guess that proves I'm not crazy since the palette shortcuts don't work either. We got Tab back which is actually a big win lol so maybe the rest will come later. I primarily used the comment line and run query the most.