How to execute a query in VS Code for Cosmos DB?
I have installed an extension for having access to a Microsoft Azure Cosmos DB in VS Code, and I'm able to see the documents inside as expected.
However, I wasn't able to figure out how to run a query that allow me to filter results based on different conditions e.g: SELECT * FROM c WHERE c.DocumentId = 123
Is there a way to run SQL queries in VS Code on a Cosmos DB? I couldn't find any helpful tutorial and by installing "mssql" extension seems that is mainly focused on ADO.NET connections.
Based on the statements in the cosmos db extension:
Browse and query your MongoDB databases both locally and in the cloud using scrapbooks with rich Intellisense then connect to Azure to manage your Cosmos DB databases with support for MongoDB, Graph (Gremlin), and SQL (previously known as DocumentDB).
You could follow below official example of Scrapbooks to query your sql api db with mongo shell syntax.
E.G.
db.coll.find({"DocumentId" :123})
Update:
Sorry for the late updates. I got 2 tools for you:
1.CosmosDbExplorer :https://www.bruttin.com/CosmosDbExplorer/
2.Azure Storage Explorer: https://azure.microsoft.com/en-us/features/storage-explorer/
- Compiling C Program in VS code using Code runner
- VSCode Python extension loading forever, saying “Reactivating terminals”
- cant use sudo, apt ,npm, etc in my vscode terminal even though I have Ubuntu bash installed on Windows 10
- Why a certain keys on my keyboard not working in VS code
- How do I turn off "Contains emphasized items" in Visual Studio code?
- Automatically hard wrap lines at column in VSCode
- Visual studio code - how to copy search results?
- Adding "Close to the Left" to the tabs context menu in VS Code
- How can I make all line endings (EOLs) in all files in Visual Studio Code, Unix-like?
- Open multiple Projects/Folders in Visual Studio Code
- How to filter out files with certain file extensions in VSCode?
- VS Code Intelephense Clear Cache and Reload
- How to change VSCode search highlight color
- VSCode: Add custom autocomplete to known external classes
- Vscode: How to disable auto breaking too long lines?
- Visual Studio Code source control not showing changes
- How do I trigger suggestion(s) in VSCode in Catalina?
- VS code shortcut to wrap multiple lines of text in same tag?
- Make vscode's git integration cancel push if behind remote (instead of automerging)?
- Preferences don't saving in unity
- How do I debug HTML and JavaScript together in VSCode (Visual Studio Code)?
- VSCode: How to see blocks with a list of branches, stashes, etc. again?
- VSCode Snippets: conditional import based on file path
- VS Code not doing type checking on typescript files
- Is there a cursor overwrite/overtype mode in VS Code?
- Disable Undefined Property error in PHP Devsense extension on VSCode
- How to set CMake build configuration in VSCode?
- How to accept only the next word in GitHub Copilot suggestion?
- VSCode :: How can I duplicate directories and files from within the file explorer?
- Get Private FQDNs, IPs, Names of the Private Endpoints for the Azure resources deployed in an Virtual Network using PowerShell Script