Using StartsWith to Filter on RowKeys
There are many scenarios where filtering on partial RowKeys makes sense. One of these scenarios is Azure Diagnostics Log analysis where events are partitioned by time based PartitionKeys and by compound RowKeys. This allows us to filter and find information effectively.
Event RowKeys are composed of deployment IDs, role names, instance names, categories and other information:
Querying WADLogsTable Effectively
The following example, shows how to target a specific table partition and filter events based on a StartsWith pattern.
var storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(connectionString); var client = storageAccount.CreateCloudTableClient(); var table = client.GetTableReference("WADLogsTable"); // Querying Windows Azure Diagnostics by Partition for a partial RowKey var query = new FindWithinPartitionStartsWithByRowKey("0635204061600000000", "8637d014bcf94452a"); var result = query.Execute(table);