Forum Discussion

coverturfLSH's avatar
coverturfLSH
Icon for Resolver II rankResolver II
1 year ago
Solved

Warehouse T-SQL keyboard shortcuts not working

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...
data warehouse
warehouse
  • Anonymous's avatar
    Anonymous
    1 year ago

    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!

coverturfLSH's avatar
coverturfLSH
Icon for Resolver II rankResolver II
1 year ago

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's avatar
mikeburek
Icon for Advocate III rankAdvocate III
1 year ago

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's avatar
    coverturfLSH
    Icon for Resolver II rankResolver II
    1 year ago

    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's avatar
      mikeburek
      Icon for Advocate III rankAdvocate III
      1 year ago

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

       

      Yes, computer intelligence only goes so far. Ha!