Cosmos SQL Container
  • 31 Jan 2022
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Cosmos SQL Container

  • Dark
    Light
  • PDF

Azure Cosmos SQL

  • Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL), one of the most familiar and popular query languages, as a JSON query language.

  • With Serverless360, it is possible to manage Cosmos SQL Containers.

  • Once an Azure Cosmos SQL Containers is associated with Serverless360's Business Application, it can be managed from a central place.

Cosmos Container

  • Cosmos SQL Database can contain any number of containers; each container can be managed separately by associating it with Serverless360.

Execute SQL Queries

  • Serverless360 extends its capability to execute SQL Queries without a need to switch to any database management tools.

Execute Query.png

  • Users can also save a query and run the associated stored procedures.

  • The saved queries can be opened by clicking the Open query option availabe at the top of the section.

Saved query.png

Stored Procedures

The stored procedures present in the container will be listed by:

  • selecting the required procedure
  • providing the appropriate input,

Users can execute the stored procedures in Serverless360.
Stored Procedure.gif

SELECT queries and Stored Procedures can only be executed from Serverless360. DML and DDL statements are restricted to prevent SQL injection attacks.

Managing Container item

  • Users can select the results from the executed query and choose to perform either deletion or update of that item.

  • Bulk deletion of items is also possible. On clicking the item id, a blade will be displayed where users will be able to edit and update the item.

Delete- Update Container item.gif

Serverless360 also provides the capability to save the queries that are frequently used, so that the process of manually entering the query can be eliminated.

Resource Dashboard

Users now have access to a default Cosmos SQL Container Dashboard within the Cosmos SQL Container resource, which allows them to keep track of dynamic real-time data with improved data visualisation.

Cosmos SQL Container.png

Users are provided with the following pre-defined Dashboard widgets, which can be customised to meet their specific needs.

1. Metadata Requests
2. Total Requests vs Total Request Units
3. Cosmos Container Summary
4. Total Requests

Monitoring

  • Users can monitor their Cosmos SQL Container resources by configuring the rules available for monitoring.

  • Navigate to the Monitoring section of the resource to configure the monitoring rules for Cosmos SQL Container.

  • Users can specify monitoring threshold values based on their needs.

  • When the monitoring rule type is a metric, selecting metric against metric rules is also an option.

Monitor rules.png

Properties

  • Users can view the properties of the containers in the Properties section.

Cosmos SQL Container- Properties.png

  • JSON view of the properties is also available in Serverless360.

Was this article helpful?