- 13 Oct 2020
- 1 Minute to read
Cosmos SQL Management
- Updated on 13 Oct 2020
- 1 Minute to read
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.
Users can view the properties of the Database and containers by clicking the 'Properties'.
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.
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.
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.
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.