Cosmos SQL Management
  • 13 Oct 2020
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Cosmos SQL Management

  • Dark
    Light
  • PDF

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'.

properties.PNG

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.

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.
cosmos-container-query1.gif

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.

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

procedure1.gif

We'd love to hear your thoughts

Please visit our feedback system to suggest new Features or Enhancements. You can also look at our Roadmap


Was this article helpful?