Skip to main content

Azure DocumentDB - Bulk Add Documents and Query Syntax Highlighting

Posted on November 12, 2014

Director of Product, Azure Data
We’ve released a couple of great improvements to further enhance the management experience for DocumentDB, the fully managed NoSQL document database service on Azure. We just released the following capabilities in the new Azure portal at
  • Bulk add Documents – Upload multiple existing JSON documents via Document Explorer
  • Query syntax highlighting – Keyword and value highlighting in Query Explorer
  • Improved query experience – Edit and re-execute queries without closing the results blade
  Keep reading for additional information on each of these new features or get started now with DocumentDB!

Add Documents

Document Explorer allows you to easily create, edit, and delete JSON documents stored in DocumentDB and is available from any of the DocumentDB account, database or collection blades: DocumentExplorerPart With this release, Document Explorer now supports upload of multiple existing JSON documents. Simply open Document Explorer from any of the aforementioned blades and click the “Add Document” command: AddDocumentCommand A new blade will open. Click the browse button to open a file explorer window and select 1 or more JSON documents to upload. Note that Document Explorer currently supports up to 50 JSON documents per upload operation: AddDocuments   Once you’re satisfied with your selection, click the upload button. The documents will automatically be added to the Document Explorer grid and results will be displayed as the upload operation progresses: AddDocuments-Results Once the operation has completed, you can select up to another 50 documents to upload.

Query Explorer- Syntax Highlighting

Query Explorer allows you to author, edit, and run DocumentDB SQL queries against any of your DocumentDB collections. Similar to Document Explorer, Query Explorer is available from any of the DocumentDB account, database, and collection blades: QueryExplorerParts In this release, we’ve enabled basic keyword and value highlighting within Query Explorer to improve the query authoring experience: QueryExplorer

Query Explorer – Rerun queries

Finally, we’ve modified the Query Explorer blade so that you can run, edit and re-run queries without having to close the results blade: QueryExplorer-ReRun Query As always, we’d love to hear from you about the DocumentDB features and experiences you would find most valuable within the Azure portal. Please submit your suggestions on the Microsoft Azure DocumentDB feedback forum. If you haven’t tried DocumentDB yet, then get started here. Enjoy!