vscode-cosmosdb icon indicating copy to clipboard operation
vscode-cosmosdb copied to clipboard

Published 20 hours ago • verified publisher icon microsoft

SQL Scrapbooks

Open peterbb148 opened this issue 5 years ago • 8 comments

Support for developing and testing queries against CosmosDB in SQL mode in a client with any type of developer experience is completely lacking.

Please extend the CosmosDB add-on to VSCode with an experience similar to MongoDB scrap books so that queries can be developed, tested and saved between sessions. Also include all information returned from CosmosDB in the Http header from the API like request charge and so on.

peterbb148 avatar Mar 08 '19 06:03 peterbb148

This is sorely lacking and we need this. The Azure Data Explorer in the Portal is terribly slow to work with.

rajeevac avatar Mar 08 '19 18:03 rajeevac

There were five votes for this in https://github.com/Microsoft/vscode-cosmosdb/issues/326 and https://github.com/Microsoft/vscode-cosmosdb/issues/822. Note the request to enable this for all accounts, not just those with SQL as the default interface.

cc @chrisdias @johnpapa @bryceg @julielerman

StephenWeatherford avatar Mar 08 '19 18:03 StephenWeatherford

Is this the right issues for us to track ? The other 2 are closed, like this one.

johnpapa avatar Mar 08 '19 19:03 johnpapa

Thanks, somehow accidentally closed this one.

StephenWeatherford avatar Mar 08 '19 19:03 StephenWeatherford

no worries - thought i missed the right one

I'm excited to see this feature!

johnpapa avatar Mar 08 '19 19:03 johnpapa

Oddly me2 :-)

Hope this gets traction!

peterbb148 avatar Mar 08 '19 19:03 peterbb148

:slightly_smiling_face: This feature request received a sufficient number of community upvotes and we moved it to our backlog. To learn more about how we handle feature requests, please see our documentation.

Happy Coding!

AzCode-Bot avatar Apr 06 '22 05:04 AzCode-Bot

Is this started in a Beta? Is there any ETA?

kwitcom avatar May 05 '22 17:05 kwitcom

Is this problem sloved, if yes please share. We need something like Scrapbook for SQL API, it has been very annoying working with portal. Thanks

redar84 avatar Oct 17 '22 15:10 redar84

@fiveisprime Could you please give an update on this feature? This issue is open for 4 years now and developers and other IT personnel out there struggle with this shortcoming every day.

sit-md avatar Mar 20 '23 08:03 sit-md

I am just deployed to this project. This looks like a good feature to add. I am working on a prototype now and will update here once I get more details finalized.

JasonYeMSFT avatar Nov 30 '23 00:11 JasonYeMSFT

The work has been merged. It will be included in the 0.21.0 release.

JasonYeMSFT avatar Feb 15 '24 19:02 JasonYeMSFT

@JasonYeMSFT That's great! Thank you for implementing this! Will it also provide a possibility to export the queried results?

sit-md avatar Feb 16 '24 07:02 sit-md

@sit-md Exporting the query result won't be supported in 0.21.0. The query result would be presented in a JSON document and for now you will need to manually parse the results.

JasonYeMSFT avatar Feb 16 '24 17:02 JasonYeMSFT