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

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

Categories: Storage
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: