topic Re: Warehouse T-SQL keyboard shortcuts not working in Data Warehouse

Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Tue, 01 Oct 2024 19:32:33 GMT

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

Re: Warehouse T-SQL keyboard shortcuts not working

Anonymous — Fri, 04 Oct 2024 06:35:15 GMT

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!

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Fri, 04 Oct 2024 15:16:01 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Wed, 16 Oct 2024 18:14:33 GMT

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

Re: Warehouse T-SQL keyboard shortcuts not working

mikeburek — Thu, 17 Oct 2024 17:59:53 GMT

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)

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Thu, 17 Oct 2024 18:02:36 GMT

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

Re: Warehouse T-SQL keyboard shortcuts not working

mikeburek — Thu, 17 Oct 2024 19:50:31 GMT

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

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Thu, 17 Oct 2024 19:54:12 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

mikeburek — Thu, 17 Oct 2024 20:53:01 GMT

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

Re: Warehouse T-SQL keyboard shortcuts not working

mikeburek — Thu, 17 Oct 2024 20:55:58 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Thu, 17 Oct 2024 21:00:44 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

mikeburek — Thu, 17 Oct 2024 21:16:21 GMT

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

Yes, computer intelligence only goes so far. Ha!

Re: Warehouse T-SQL keyboard shortcuts not working

arpost — Thu, 17 Oct 2024 21:33:57 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Thu, 17 Oct 2024 21:38:42 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

JakeTully — Wed, 23 Oct 2024 18:25:14 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

JakeTully — Wed, 23 Oct 2024 18:25:40 GMT

+1, having the same issue.

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Wed, 23 Oct 2024 18:28:32 GMT

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.

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Tue, 14 Jan 2025 16:26:28 GMT

CTRL+Enter started working yesterday (Jan 13, 2025). So we've gotten back Tab and CTRL+Enter since the copilot integration. Really just missing the comment shortcut and then I'll be a happy user again.

Re: Warehouse T-SQL keyboard shortcuts not working

coverturfLSH — Tue, 25 Feb 2025 23:43:38 GMT

CTRL+/ started working again today 2/25/2025 to comment lines out!