Cerulean

Azure Cosmos DB

Cosmos DB Table API

Databases

Using Cerulean you can list the databases that are there in your Cosmos DB account.

Using Cerulean you can create new database in your Cosmos DB account. When creating a database, you can assign a dedicated throughput for that database (and all containers in that database will share that throughput).

Please note that you can either create a database with throughput or without throughput. While you can change the throughput on the database created with a provisioned throughput anytime, what you can't do is remove the throughput (assuming the database is created with throughput) or assign throughput (assuming the database is created without throughput) after a database is created.

Further note that there can be only one database in your Cosmos DB accounts targeting Table API and the name of that database must be "TablesDB". Cerulean prevents you from creating a database by any other name.

Using Cerulean you can delete one or more databases from your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a database in your Cosmos DB account.

If a database is created with a provisioned throughput, using Cerulean you can change the throughput of that database on the fly.

Tables

Using Cerulean you can list the tables that are there in a database in your Cosmos DB account.

Using Cerulean you can create a new table in a database in your Cosmos DB account. Cerulean provides a comprehensive set of features for creating a table.

  • If a table is being created in a database with a provisioned throughput, it gives you an option of using either database throughput (i.e. table will share database's throughput) or specify a throughput at the table level. If a table is being created in a database without a provisioned throughput, then you will be asked to specify a throughput for the table.
  • While all other tools expect you to specify indexing policy on a table in JSON format, Cerulean gives you an easy-to-use interface to specify indexing policy. Using Cerulean's interface you can specify indexing mode (consistent, lazy or none), included and excluded index paths, composite indexes and spatial indexes. No other tool gives you this feature.
  • Using Cerulean you can specify unique key policy on a table at the time of container creation. Please note that it is not possible to modify unique key policy once a container is created.
  • Using Cerulean you can specify table's time-to-live policy at the time of creation. This policy essentially controls if the entities in the table should expire automatically (if so, then after what time) or not.

Using Cerulean you can delete one or more tables from a database from your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a table in a database in your Cosmos DB account.

If a table is created with a provisioned throughput, using Cerulean you can change the throughput of that table on the fly.

Cerulean enables you to manage indexing policy on a table using an easy-to-use interface. It enables you to change indexing mode (consistent, lazy or none), included paths and excluded indexing paths, composite indexes and spatial indexes.

Using Cerulean you can view the unique key policy defined on a table. Please note that it is not possible to update unique key policy on an existing table.

Using Cerulean you can delete entities matching a query from a table in your Cosmos DB account. If no query is specified, then all entities from a table will be deleted. No other tool gives you this feature.

This is another nifty feature in Cerulean wherein you can copy a table in a database and paste it. This action will copy either entities matching a specified query or all entities from source table to target table.

What's interesting about this feature is that your source and target can either be a Cosmos DB table or a Storage table. In other words, you can copy entities from a Storage table to a Cosmos DB table and similarly copy entities from a Cosmos DB table to a Storage table.

This is another neat feature of Cerulean where you can download all entities from a table to your local computer.

Cerulean enables you to download the entities in JSON, CSV or Typed CSV format.

Entities

Cerulean provides robust querying capabilities using which you can query the entities that are present in a table in your Cosmos DB account. It also includes a "validate query" feature using which you can validate the query before executing it.

Cerulean enables you to specify additional query options like number of records / page, what all attributes of an entity you wish to fetch as part of query result (query projection) apart from specifying the query text.

Pagination to view query result (entities) is supported by default and you can easily navigate from one page of results to another page using Cerulean.

This is a nifty productivity feature in Cerulean which enables you to save your commonly used queries inside the application so that you don't have to type the query over and over again. You can assign a friendly name to a query (e.g. "My Documents" for "PartitionKey eq 'Some-Partition-Key'" query) and all you have to do is select that friendly name to bring up that query. You can also set a query as default query and that query will be selected by default whenever you open entities tab.

Using the query manager, you can edit any saved query by simply changing the query text and/or parameters. It's that simple. Furthermore you can delete saved queries as well.

You can export queries in JSON format and import them back. This becomes quite handy when you wrote queries against a table in one account and want to use the same queries against another table in same or different account.

Query builder (designer) is another utility in Cerulean using which you can construct your OData queries against your tables with great ease.

All you would need to do is select the attributes on which you wish to create a query, specify the operator (equal, not equal, greater than, less than etc.), specify their values based on the attribute type and specify logical connectors (and, or) and query builder will build the OData query for you.

It also includes date/time utilities using which you can choose from a set of predefined dates and the query builder will take care of necessary conversion and formatting things.

Using Cerulean you can add an entity to a table in your Cosmos DB account.

One interesting feature of Cerulean is that for "Edm.Binary" type entity attribute, it enables you to select a file from your local computer and Cerulean automatically converts the contents of that file to a Base64 encoded string (as expected by the table service).

Using Cerulean you can update an entity in a table in your Cosmos DB account. While updating an entity, you can either merge changes to the parent entity (in case you fetched partial entity via query) or replace the entity completely.

Another unique feature of Cerulean is that it would let you edit PartitionKey and/or RowKey of an entity as part of update process. Considering Cosmos DB table does not allow it, Cerulean will first try to create a new entity with new PartitionKey, RowKey and attributes and then delete the old entity.

Cerulean will let you select multiple entities displayed as part of query result and delete them together. For deleting all entities that match a particular query, please see "Purge entities" feature under Tables section above.

Cerulean is the only tool that will let you edit multiple entities together. This becomes a handy feature when you want to add an attribute, update an attribute value or remove an attribute in more than one entity.

Cerulean is the only tool that will let you duplicate an entity. Using this feature you can quickly create a new entity based on an existing entity.

This is another neat feature of Cerulean where you can customize how you would like to see the entities fetched as part of query result. You can not only customize the attributes you want to see but also control the order in which you wish to see these attributes.

This is another neat feature of Cerulean where you can select one or more of displayed entities (or all entities matching a query criteria) and copy them to another table.

What's interesting about this feature is that your source and target can either be a Cosmos DB table or a Storage table. In other words, you can copy entities from a Storage table to a Cosmos DB table and similarly copy entities from a Cosmos DB table to a Storage table.

This is another neat feature of Cerulean where you can select one or more of displayed entities (or all entities matching a query criteria) and download them to your local computer.

Cerulean enables you to download the entities in JSON, CSV or Typed CSV format.

Stored Procedures

Using Cerulean you can list the stored procedures that are there in a table in your Cosmos DB account.

Using Cerulean you can create a stored procedure in a table in your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a stored procedure in a table in your Cosmos DB account.

Using Cerulean you can delete one or more stored procedures from a table in your Cosmos DB account.

Using Cerulean you can update a stored procedure in a table in your Cosmos DB account. Updating a stored procedure includes changing the body of a stored procedure.

Using Cerulean you can execute a stored procedure from the application itself. For executing a stored procedure, Cerulean provides an easy to use interface to define input parametes. Cerulean also enables you to choose the type of partition key (string, numeric, object, undefined etc.) and specify value of the partition key accordingly.

Cerulean not only displays the output of the stored procedure but also shows you any console.log statements you have put in the procedure. It also shows you the request units you have consumed for executing a stored procedure.

Triggers

Using Cerulean you can list the triggers that are there in a table in your Cosmos DB account.

Using Cerulean you can create a trigger in a table in your Cosmos DB account. When creating a trigger, you can specify trigger operation (all, create, delete or replace), trigger type (pre or post) and trigger body.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a trigger in a table in your Cosmos DB account.

Using Cerulean you can delete one or more triggers from a table in your Cosmos DB account.

Using Cerulean you can update a trigger in a table in your Cosmos DB account. Updating a trigger includes changing the body, operation, and/or type of a trigger.

User Defined Functions

Using Cerulean you can list the user defined functions that are there in a table in your Cosmos DB account.

Using Cerulean you can create a user defined function in a table in your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a user defined function in a table in your Cosmos DB account.

Using Cerulean you can delete one or more user defined functions from a table in your Cosmos DB account.

Using Cerulean you can update a user defined function in a table in your Cosmos DB account. Updating a user defined function includes changing the body of a user defined function.

Users

Using Cerulean you can list the users that are there in a database in your Cosmos DB account.

Using Cerulean you can create a user in a database in your Cosmos DB account.

Using Cerulean you can view system defined properties (e.g. _rid, _self, _ts, and _etag etc.) of a user and also update the name of the user.

Using Cerulean you can delete one or more users from a database in your Cosmos DB account.

More Cosmos DB Features