Azure DocumentDB Query Playground

DocumentDBHeader

Azure DocumentDBDocumentDBLogo is Microsoft’s NoSQL database service. It is a document-oriented database that stores schema-free JSON data that can be queried using a SQL-like language. These databases are excellent for developers who want to get their projects up and running quickly.

Saving data to a document collection is one hurdle developers must tackle and the other is retrieving the data back out. Fortunately for us, Microsoft has created a sandbox with sample data to experiment with. Called the Query Playground, the site allows you to run complex queries against test data in an interactive environment.

 

DocumentDB01

You can learn the query syntax through topics like Filtering, Order By, Top, Projection, and others. If you want to see the structure of the data, click the Sample Docs link above the Results window. Then once you are ready to create your own custom queries, use the Sandbox tab to retrieve data from the integrated USDA nutrition dataset. As an example, look up information on pasta.

DocumentDB02

Finally, if you need additional help writing queries using the SQL-like syntax, check out this DocumentDB SQL query cheat sheet PDF.

DocumentDB SQL query cheat sheet PDF

Advertisements

About Ken Cenerelli
I am a Programmer Writer, .NET Developer, Microsoft MVP - Visual Studio and Development Technologies, Public Speaker, Blogger, and Microsoft Azure Nerd. I blog regularly at kencenerelli.wordpress.com and can be found on Twitter via @KenCenerelli.

2 Responses to Azure DocumentDB Query Playground

  1. Pingback: Azure DocumentDB Query Playground - Top Big Data News

  2. Pingback: Azure Weekly: Apr 3, 2017 – Build Azure

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: