Storage

How can we improve Azure Storage?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add TableStorage LINQ query support for Select, Count and Contains

    Critical functions such as Select, Count and Contains are not currently available when querying TableStorage data.

    If I only want a total number of rows that match a certain criteria I have no choice but to retrieve the data, count it and throw it away.

    Adding support for Select would also help with heavy queries by only returning the data selected from a query.

    Contains would be useful for searching. Using the Compare function is annoying.

    1,557 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      45 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
    • Support secondary Indexes

      Need to be able to sort on something other than the rowkey

      1,259 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        80 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
      • Provide me with full text search on table storage

        Does what it says on the tin....really need better search capabilities over azure table storage.

        908 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          41 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →

          A common need for users of Azure Table Storage is searching data in a Table using query patterns other than those that Table Storage provides efficiently, namely key lookups and partition scans. Using Azure Search, you can index and search Table Storage data (using full text search, filters, facets, custom scoring, etc.) and capture incremental changes in the data on a schedule, all without writing any code. To learn more, check out Indexing Azure Table Storage with Azure Search: https://docs.microsoft.com/en-us/azure/search/search-howto-indexing-azure-tables

        • Add ability to view Azure Table size/entity count (rows)

          Hi Mike,

          I've created this idea as suggested on the forums: http://social.msdn.microsoft.com/Forums/en/windowsazure/thread/ea18ae29-36a3-42c6-8420-877216efbd42

          One of the big challenges in adopting azure table storage over traditional SQL storage is the ability to know how much data is stored and how it is being used.

          Being able to break size/rows down by partition would be invaluable when trying to modify / optimize Partition & Row keys. (Given data doesn't always grow as we would expect, and new bottlenecks can & will emerge).

          In addition the ability to view the usage data per table / partition would be fantastic.

          Obviously there are ways of…

          721 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            8 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
          • Ability to delete from Table Storage by Partition

            There is no good way to delete multiple entries in Table Storage. All you can do is delete one at a time. For logging tables this can become VERY expensive. It would be great if we had the ability to use Partitions as a way to delete logical groups of data in Table Storage in a single transaction.

            This would allow for a partitioning scheme for grouping data in units that can easily be deleted. For example, logging data in WADLogsTable or rolling tables of data captured on a given partition can be archived easily and cleaned up.

            380 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              4 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
            • Add an atomic Increment operator on table storage. See MongoDB for example.

              It's hard to create pre-aggregated counters in table storage when using multiple workers. For example, a page hit counter will have wrong counts if incremented by pulling work from a queue and updating an entity representing the page using multiple workers.

              246 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                under review  ·  1 comment  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
              • Entity Framework provider for Azure Storage

                Even if clearly impossible to have all relational features implemented, a mapping between EF entities and Azure Storage tables would be great, as would simplify the migration of the data layer to Azure.

                140 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  under review  ·  4 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                • Support "skip" in Azure Table

                  MSDN says the "take" operator is only supported for the first 1,000 rows...

                  I need to access row number 5,000 in a highly partitioned storage layout. Support for "skip" is a requirement if we are to continue development.

                  127 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    under review  ·  4 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add Support for Lists/Arrays in Azure Tables

                    Azure tables need an option to support lists/arrays for per entity instance.

                    Both Google App Engine (http://code.google.com/appengine/docs/python/datastore/typesandpropertyclasses.html#ListProperty) and Amazon's simpledb both already offer this.

                    It enables an effective way to relate entities without the over head of traditional SQL.

                    101 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      2 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                    • Azure Table Storage permissions to prevent deletion

                      It would be nice to be able to lock certain areas of Azure Storage to prevent operators/developers from deleting a table/container/queue by accident. Our specific need right now is for Azure Storage Tables but could potentially be for containers and queues. For example, it would be nice to lock a table to not allow deletion.

                      97 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        5 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow me to pay for increased entities/second from a table storage account

                        Amazon's DynamoDB offers the ability to scale access to a single table, while Azure Table Storage is limited to 5000 entities/account. With Azure Federations now in place, this seems like the last remaining bottleneck for my application as it grows.

                        Spreading my data across multiple accounts is a suboptimal solution because (1) it requires an additional layer of complexity in my application, (2) these accounts are not free in that I must request more of them from Microsoft myself every time I need more, (3) I'm not guaranteed to get more than 20 (5 to start, 20 if you go…

                        79 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          4 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                        • Extend Table Storage Property Limit

                          Currently, Azure Tables only support 255 properties (columns) on a single entity (row) and a max row size of 1MB. This should be greatly extended (e.g. 10x+), particularly since Azure does not offer Join query support. Without Join support, devs are forced to span large data structures across multiple tables. When querying the data, devs have to manage this extra complexity as well as suffer the performance penalties of querying against N tables and then performing their own post-join operation. Azure Tables scale great in one dimension (# rows), but horribly in the other (# columns). While Azure Tables should…

                          70 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            3 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                          • Modify Azure portal to be able to monitor capacity (size) of Azure Tables

                            Currently in Ibiza portal we can see the capacity (storage size usage) but only for blobs. The only way to know what is the size used by Azure tables is to manually calculate it (See: http://blogs.msdn.com/b/windowsazurestorage/archive/2010/07/09/understanding-windows-azure-storage-billing-bandwidth-transactions-and-capacity.aspx)

                            This process takes a lot of time, it cost money (since it requires to download tables) and slow (cannot be monitored every X minutes.

                            43 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add autonumber index with identity increment column like sql server and DocumentDB

                              Don't want to worry about index column like i do on the row key.
                              Please add column id with auto identity increment.

                              41 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add support for gzip and/or deflate on Table Storage

                                I noticed that the Storage team has gone to great lengths to reduce bandwidth usage by switching to JSON. Take this to the next logical step and add support for the Accept-Encoding header in the client libraries and have the server return content gzipped or deflated. JSON compresses quite nicely, especially if the entities returned from a query are similar, which they nearly always will be if you're querying on PartitionKey and RowKey

                                40 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  2 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                                • 30 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Please give us Count(), TakeLast(int i), Skip(int i)

                                    There are many Scenarios were count is useful. Ich I write logs to Azure Tables most of the time i want to retreive the last n entries. It would be great if there would be something like TakeLast(int i) or Skip(int i) for doing something like Skip(count - take).Take(take).

                                    30 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Azure table storage should have a way to set the retention policy

                                      There should be a way to implement a Azure table storage retention policy such that anything older than n number of days can be deleted from table storage.

                                      29 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Let's sunset "One of the request inputs is not valid." to never be seen again

                                        This is the most useless message ever. Also let the "valid" inputs succeed and return the bad ones.

                                        29 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          under review  ·  0 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Provide "ForceSerializeAttribute" for TableEntity-derived properties and fields

                                          In a sense, it would be the opposite of the existing "IgnorePropertyAttribute" by forcing the serialization of decorated fields and properties (even if it they are private)

                                          28 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Tables  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base