Working with Windows Azure Storage –Azure Table Storage – PowerShell Part – 1

Azure Table Storage is a fault-tolerant, ISO 27001 certified NoSQL key-value store. Azure Table Storage can be useful for applications that must store large amounts of non-relational data, and need additional structure for that data. Tables offer key-based access to un-schematized data at a low cost for applications with simplified data-access patterns. While Azure Table Storage stores structured data without schemas, it does not provide any way to represent relationships between the data.

Despite some notable differences, Microsoft Azure SQL Database and Azure Table Storage are both highly available managed services with a 99.9% monthly SLA.

There are couple of free tools to work with Azure Storage (Blob / Tables / Queues). The one i most of the time use is Azure Storage Explorer. There is not GUI available on

https://portal.azure.com or https://manage.windowsazure.com

Download the tool and configure it by clicking Add Account (You need storage account,storage account key)

image

image

image

By Default 2 keys columns where created which cannot be deleted or modified.More columns can be added  by click View Button

image

In this example i have customer deta feed files in .csv format which i am uploading it to Azure Table from my local computer. You can also use the blob storage or VPC storage for faster upload. As i am uploading it over internet the upload will be slow depending upon the link.

Click on the View button

image

select the file, pass the partition Key Name (Unique record) and RowKey (rowguid).Click  upload

image

image

As the data is uploading you can click refresh to see how the data is uploading.

We can use the monitoring section in the https://manage.windowsazure.com

image

Check Azure Tables using PowerShell

image

How pricing / Billing is calculated for Blob / Storage Table / Queue read this article carefully.http://blogs.msdn.com/b/windowsazurestorage/archive/2010/07/09/understanding-windows-azure-storage-billing-bandwidth-transactions-and-capacity.aspx

Leave a Reply

Your email address will not be published. Required fields are marked *