Cosmos SQL Management

Cosmos SQL

Azure Cosmos DB is Microsoft's globally distributed, multi-model database service for operational and analytics workloads. 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 and monitor Cosmos SQL Database and Containers.
Once an Azure Cosmos SQL Database and Containers is associated with Serverless360's Composite Application, it can be managed and monitored from a central place.

View Properties

Users can view the properties of the Database and containers by clicking the 'Properties'.

Cosmos Container

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

Execute SQL Queries And Procedures

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

Delete/Update Container Item

The 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 the users having 'Manage' permission will be able to edit the item and update it.

These operations will be captured in the Governance & Audit record corresponding to this action. These details can also be exported to Excel or PDF format using the export capability in Governance & Audit.

Stored Procedure

The stored procedure present in the container will be listed; by selecting the required procedure and providing the appropriate input, the users can execute the stored procedures.