Cerulean

Azure Storage

Table Storage

Tables

Using Cerulean you can list the tables that are there in your storage account.

Using Cerulean you can create a new table in your storage account.

Using Cerulean you can delete one or more tables from your storage account.

This is a neat feature in Cerulean where you can delete all tables from a storage account with a single click. This is typically useful when you want to reinitialize your storage account where instead of selecting all tables individually and deleting them, you can simply delete all tables in one click.

Assuming you have a large number of tables in your storage account and you need to work with just one particular table. Navigating through the list of tables to find that particular table can be quite cumbersome and counter productive.

This is another productivity feature of Cerulean where you can search for table(s) you are looking for. You can perform a "prefix" search (i.e. find all tables, names of which begin with certain characters) or "contains" search (i.e. find all tables, names of which contain certain characters).

This is yet another productivity feature in Cerulean wherein you can quickly open a table by simply typing the name of that table. This becomes quite handy when you have a large number of tables in your storage account and you don't want to navigate through the list to find the table you want to work with.

Using Cerulean you can manage (view or update) access policies for a table. You can add new access policy, update existing policies or delete access policies using Cerulean. Access policies are used for creating shared access signature for that table.

Using Cerulean you can create Shared Access Signature (SAS) for a table. You can create an ad-hoc SAS token/URL (i.e. without using any queue access policy) or a SAS token/URL with a table shared access policy.

This is another nifty feature in Cerulean wherein you can copy a table 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.

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

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

Table Service

Using Cerulean you can configure storage analytics settings for the table service in your storage account.

You can configure (view/update) logging, minute metrics and hourly metrics settings for the table service in your storage account.

Using Cerulean you can configure CORS settings for the table service in your storage account.

Using Cerulean you can list the CORS rules defined for the table service, add new CORS rule, update existing CORS rules or delete CORS rules.