269 questions
61
votes
3
answers
70k
views
How to get all rows in Azure table Storage in C#?
I am trying to get a list of all entities inside an azure table.
Any idea of how I would write this query?
44
votes
3
answers
59k
views
NoSQL: Getting the latest values from tables DynamoDB/Azure Table Storage
I have a little problem that needs some suggestions:
Lets say we have a few hundred data tables with a few dozen million rows each.
Data tables are timestamp(key) - value
Data tables are written once ...
144
votes
23
answers
90k
views
Azure table storage returns 400 Bad Request
I ran this in debug mode, and I attach an image with the details of the exception. How can I know what went wrong? I was trying to inset data in a table. Can't azure give me more details?
Obs: The ...
78
votes
29
answers
82k
views
Azure Storage Emulator error and does not start
This error is really driving me crazy. (Terminal running in administrator mode)
Initialization of azure storage emulator in sql server 2014:
C:\Program Files (x86)\Microsoft SDKs\Windows Azure\...
15
votes
7
answers
10k
views
Windows Azure - Cleaning Up The WADLogsTable
I've read conflicting information as to whether or not the WADLogsTable table used by the DiagnosticMonitor in Windows Azure will automatically prune old log entries.
I'm guessing it doesn't, and ...
1
vote
2
answers
4k
views
Very Slow on Azure Table Storage Query on PartitionKey/RowKey List
GET /Product()?$filter=((PartitionKey%20eq%20'lIkfA81JpTmv')%20and%20(RowKey%20eq%20''))
%20or%20((PartitionKey%20eq%20'lIGcEmrr7hWz')%20and%20(RowKey%20eq%20''))
%20or%20((PartitionKey%20eq%20'...
0
votes
1
answer
398
views
Console app to use azure storage tableapi
Please provide some examples (console application) on sending http request to query an azure table storage using OData?
81
votes
5
answers
17k
views
When should I use Sql Azure and when should I use table Storage? [closed]
When should i use Sql Azure and when should I use table Storage?
I was thinking , use table storage for transaction processing scenarios e.g. debit credit accounts kind of scenario and use Sql Azure ...
14
votes
4
answers
10k
views
Fastest way of querying for latest items in a Azure table?
I have a Azure table where customers post messages, there may be millions of messages in a single table. I want to find the fastest way of getting the messages posted within the last 10 minutes (which ...
11
votes
3
answers
12k
views
Azure Functions Table Binding: How do I update a row?
I am trying to update a row in an Azure table based on an Azure Function. I see that the Table bindings can handle an ICollector which has an Add method which will add a row. I also see that you use ...
11
votes
1
answer
7k
views
How to achive more 10 inserts per second with azure storage tables
I write simple WorkerRole that add test data in to table. The code of inserts is like this.
var TableClient = this.StorageAccount.CreateCloudTableClient();
TableClient.CreateTableIfNotExist(TableName)...
10
votes
4
answers
25k
views
Timestamp query in Azure
I am really stuck in my query filter on Azure table storage.
May I know how to query with timestamp please?
When I query for partition key to 1005 alone, I am getting the complete table which I don't ...
4
votes
4
answers
7k
views
How to get more than 1000 entities from an azure table storage query?
I have read that azure table storage queries give maximum of 1000 entities and we have to make use of continuation tokens to fetch the next set of entities. I am just looking for an easy way to do ...
4
votes
1
answer
1k
views
How to retrieve Saved Conversation Data in Azure (Tablelogger)
i was able to saved conversation data using the tablelogger.cs implementation TableLogger.cs
I followed this tutorial to save the conversation history.
Logging Conversation History
The code i used ...
2
votes
4
answers
8k
views
How do I use Azure TableClient 2.0 BeginExecuteQuerySegmented
I'm trying to get all entries in my table asynchronously but am unable to figure out how to work with the continuation token. I suspect I need to take my anonymous method and convert it to a delegate,...
49
votes
6
answers
18k
views
Where can I get a list of Unicode chars by class? [closed]
I'm new to learning Unicode, and not sure how much I have to learn based on my ASCII background, but I'm reading the C# spec on rules for identifiers to determine what chars are permitted within Azure ...
44
votes
5
answers
23k
views
Microsoft Azure DocumentDB vs Azure Table Storage
For several recent years, Microsoft offers a "NoSQL" key/value storage, called "Table Storage" (http://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-tables/)
Table ...
43
votes
5
answers
33k
views
Azure Table Storage RowKey restricted Character Patterns?
Are there restricted character patterns within Azure TableStorage RowKeys? I've not been able to find any documented via numerous searches. However, I'm getting behavior that implies such in some ...
40
votes
1
answer
18k
views
Difference between InsertOrMerge and InsertOrReplace TableOperations
I'm using Azure table storage for storing the data. I'm getting confused on when to use insertOrReplace and insertOrMerge. I'm using Azure SDK 1.7.
My understanding on insertOrReplace is replacing ...
34
votes
7
answers
27k
views
Querying azure table storage for null values
Does anyone know the proper way to query azure table storage for a null value. From what I've read, it's possible (although there is a bug which prevents it on development storage). However, I keep ...
26
votes
5
answers
47k
views
Get all records from azure table storage
Using this code block
try
{
StorageCredentials creds = new StorageCredentials(accountName, accountKey);
CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true);
...
26
votes
1
answer
14k
views
Azure web/worker role read configuration settings
What is the best way/recommended way to read settings from a worker/web role?
Is it:
CloudConfigurationManager.GetSetting("ConnectionString") (this I'm using)
or
RoleEnvironment....
22
votes
6
answers
34k
views
Count rows within partition in Azure table storage
I've seen various questions around SO about how to get the total row count of an Azure storage table, but I want to know how to get the number of rows within a single partition.
How can I do this ...
19
votes
1
answer
13k
views
Update RowKey or PartitionKey in Azure Table Storage
Can i update RowKey or PartitionKey properties of entity in Azure Table Storage?
I thought yes or maybe just PartitionKey but now i am trying to do that(try to change RowKey or PartitionKey) and get ...
18
votes
4
answers
9k
views
Atomic operations in azure table storage
I am looking to implement a page view counter in azure table storage. If say two users visit the page at the same time, and the current value on PageViews = 100, is it guaranteed that the PageViews = ...
17
votes
2
answers
28k
views
Querying Windows Azure Table Storage with multiple query criteria
I'm trying to query a table in Windows Azure storage and was initially using the TableQuery.CombineFilters in the TableQuery<RecordEntity>().Where function as follows:
TableQuery.CombineFilters(...
11
votes
3
answers
3k
views
Do Azure table services entities have an equivalent of NonSerializedAttribute?
If I'm trying to serialize a normal CLR object, and I do not want a particular member variable to be serialized, I can tag it with the
[NonSerialized]
attribute. If I am creating a table services ...
10
votes
2
answers
1k
views
Generic class for performing mass-parallel queries. Feedback?
I don't understand why, but there appears to be no mechanism in the client library for performing many queries in parallel for Windows Azure Table Storage. I've created a template class that can be ...
9
votes
3
answers
37k
views
How do you convert Milliseconds into a Javascript UTC date?
Given I have the number 1446309338000, how do I create a JavaScript UTC date?
new Date(1446309338000) will equal a CST time (central standard) or local time.
new Date(Date.UTC(year, month, day, hour, ...
8
votes
3
answers
12k
views
python querying all rows of azure table
I have around 20000 rows in my azure table . I wanted to query all the rows in the azure table . But due to certain azure limitation i am getting only 1000 rows.
My code
from azure.storage import ...
7
votes
1
answer
6k
views
Design of Partitioning for Azure Table Storage
I have some software which collects data over a large period of time, approx 200 readings per second. It uses an SQL database for this. I am looking to use Azure to move a lot of my old "archived" ...
5
votes
3
answers
3k
views
Precompiled Azure function and CloudTable binding output doesn't work
I'm using a precompiled Azure Function that looks:
public static async Task Run(Stream inputBlob, Stream outputJson, Stream outputXml, CloudTable schedulerTable)
The output binding looks:
{
"name":...
2
votes
3
answers
4k
views
How to store & retrieve Bot Data in Azure Table storage with directLine channel?
I'm using Microsoft Bot Framework with directLine channel. My Bot is a part of company's customer portal from where I fetch some user information and store it in BotState using stateClient as shown ...
0
votes
1
answer
649
views
Azure Function - Managed IDs to write to storage table - failing with 403 AuthorizationPermissionMismatch
I have an Azure function application (HTTP trigger) that writes to the storage queue and table. Both fail when I try to change to managed Id. This post / question is about just the storage table ...
65
votes
7
answers
25k
views
Azure Table Vs MongoDB on Azure [closed]
I want to use a NoSQL database on Windows Azure and the data volume will be very large. Whether a Azure Table storage or a MongoDB database running using a Worker role can offer better performance and ...
46
votes
4
answers
28k
views
Painfully slow Azure table insert and delete batch operations
I am running into a huge performance bottleneck when using Azure table storage. My desire is to use tables as a sort of cache, so a long process may result in anywhere from hundreds to several ...
41
votes
3
answers
28k
views
What is the azure table storage query equivalent of T-sql's LIKE command?
I'm querying Azure table storage using the Azure Storage Explorer. I want to find all messages that contain the given text, like this in T-SQL:
message like '%SysFn%'
Executing the T-SQL gives "An ...
37
votes
5
answers
68k
views
Could not load file or assembly Microsoft.Data.OData Version=5.2.0.0 error in Azure Cloud Worker Role using Table Storage
I have a very peculiar issue using Azure Table Storage. I have a .NET 4.5 project in Visual Studio 2012 where I deal with all my Azure Table Storage functions. This project/dll is referenced by two ...
23
votes
2
answers
21k
views
What is purpose of ETag in ITableEntity
for ETag in ITableEntity MSDN says:
Gets or sets the entity's current ETag. Set this value to '*' in order to blindly overwrite an entity as part of an update operation.
I am unable to undersatnd the ...
23
votes
7
answers
39k
views
Azure Table Storage - No connection could be made because the target machine actively refused it 127.0.0.1:10002
I'm developing an ASP.Net MVC & WebApi site that uses table storage in Visual Studio 2015 on Windows 8. It was working fine in the development environment (when I set UseDevelopmentStorage=true in ...
18
votes
2
answers
20k
views
The correct way to delete and recreate a Windows Azure Storage Table = Error 409 Conflict - Code : TableBeingDeleted
Im really new to Windows Azure development and have a requirement to store some data in a windows azure storage table.
This table will really only exist to provide a quick lookup mechanism to some ...
17
votes
6
answers
28k
views
Add or replace entity in Azure Table Storage
I'm working with Windows Azure Table Storage and have a simple requirement: add a new row, overwriting any existing row with that PartitionKey/RowKey. However, saving the changes always throws an ...
14
votes
2
answers
10k
views
Azure Table Storage: Ignoring a property of a TableEntity when using the Azure.Data.Tables package
I am using the new Azure.Data.Tables library from Microsoft to deal with Azure Table Storage. With the old library when you had an entity that implemented ITableEntity and you had a property that you ...
14
votes
3
answers
14k
views
Azure Storage Table size
Azure billing is based on the size of used space. Now I need to know the details. What is the size of each storage object in my storage (blob container, single table)?
It's easy to write a code that ...
13
votes
3
answers
5k
views
How do i add a CORS rule to the Azure Storage Emulator with HTTP?
To use the Azure Storage (Emulator) Table Service, i need to add a CORS rule for my TypeScript Browser App.
I want to add that rule manually using the REST interface (from Postman, not the Browser ...
13
votes
7
answers
9k
views
Retrieving many rows using a TableBatchOperation is not supported?
Here is a piece of code that initialize a TableBatchOperation designed to retrieve two rows in a single batch:
TableBatchOperation batch = new TableBatchOperation();
batch.Add(TableOperation....
12
votes
2
answers
21k
views
insert complex objects to azure table with TableServiceEntity
I was considering adding a whole complex object into a table. Having come from good old fashioned SQL approach I'd obviously separate this into tables but I'm trying a different approach. So basically ...
11
votes
3
answers
6k
views
Using POCOs when persisting to Azure Table Storage
I'm planning to use Azure Table Storage in my ASP.NET 5 (MVC 6) app and have added the WindowsAzure.Storage NuGet package, but I got really disappointed when I noticed that all my entnty models need ...
7
votes
2
answers
8k
views
Retrieve top n records from Azure Table Storage with .NET Core
Is it possible to retrieve the Top n records from the Azure Table Storage using C#? I'm using .NET Core.
It would be great if I can get some references as well.
Please note that all my entities are ...
6
votes
2
answers
5k
views
Access Azure Table Storage with Azure MSI
I recently setup my .net core application to use MSI (Managed Identity) to communicate with Azure Blob.
Does MSI work with Azure Table Storage? Can't seem to find any documentation on it.
I am ...