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 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.
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.
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.
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.
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.
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.
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
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.
- Users can view the properties of the containers in the Properties section.
- JSON view of the properties is also available in Serverless360.