Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last Updated: Mar 27, 2024

Azure Table Storage

Leveraging ChatGPT - GenAI as a Microsoft Data Expert
Speaker
Prerita Agarwal
Data Specialist @
23 Jul, 2024 @ 01:30 PM

Introduction 📃

Microsoft Azure is Microsoft's public cloud computing platform, formerly Windows Azure. It offers computation, analytics, storage, networking, and other cloud services. This article will discuss Azure Table Storage. We will also discuss the structure of Azure Table Storage.

Microsoft Azure

Azure Table Storage 📄📁

Azure Table Storage

Azure table storage is a service that provides a way to store non-relational unstructured data. The data is stored in a key/attribute pattern in a schemaless manner. Storage being schemaless provides the flexibility to store any number of keys to each record. Because of this, data stored in Azure table storage can evolve without significant changes in the database. It is used to store NoSQL structured data.

It is not a good option when you are working with relational data. Relational data has a fixed number of columns, and all the records have the same columns with the same properties. But in Azure table storage, each record can have any number of keys, and each key can have any properties. 

It is cost-effective compared to SQL storage for the same volume of data. 

Typical uses of Azure table Storage are:
 

📌 Large amounts of structured non-relational data needed to support web-scale applications are stored in Azure Table Storage.
 

📌 It provides fast querying using clustered indexing.
 

📌 It holds datasets that can be denormalized for quick access and don't need complicated joins, foreign keys, or stored procedures.

Get the tech career you deserve, faster!
Connect with our expert counsellors to understand how to hack your way to success
User rating 4.7/5
1:1 doubt support
95% placement record
Akash Pal
Senior Software Engineer
326% Hike After Job Bootcamp
Himanshu Gusain
Programmer Analyst
32 LPA After Job Bootcamp
After Job
Bootcamp

Azure Table Storage Structure 

To use the Azure Table storage, you must create an Azure Storage Account. After that, you can create different tables within your Azure storage account. Each table can contain any number of records, and each record can have any number of key/attributes.

Following are the components of Azure Table Storage:

Azure Table Storage Structure

📌 URL format: The URL format for Azure Table Storage Account is:
http://<storage account>.table.core.windows.net/<table>
The URL format for Azure Cosmos DB Table API accounts is:
http://<storage account>.table.cosmosdb.azure.com/<table>
 

📌 Azure Storage Account: There are two ways to use Azure Table Storage. To provide access to Azure storage, an Azure Storage Account is necessary. To provide access to Azure Cosmos DB, it is necessary to have a Table API account.
 

📌 Table: WIthin the Azure Storage Account, you can create tables to store non-relational structured data. A user can create any number of tables. A Table in Azure Table Storage is schemaless, so not all records need to have the same properties.
 

📌 Entity: An Entity is a record in a database. It is a set of properties. The size of an entity in Azure Storage can be up to 1 MB, and that in Azure Cosmos DB is 2 MB.
 

📌 Properties: The actual data stored in the Azure Table Storage is called a property. It is in the form of key-value pairs. Any entity can have up to 252 properties.

Create an Azure Storage table in the Azure portal

Now we will discuss creating an Azure Storage Table in the Azure portal. First, You need to create an Azure Storage Account; then, you can follow the below steps to create an Azure storage table. 

📑 Log in to your Azure Storage Account. Click OverviewTables.
 

📑 Click on the + Table icon.
 

📑 Give a name to your Table in the Table name box. Click OK.

Voila! You have created an Azure Storage Table in the Azure portal.

Frequently Asked Questions❔

What is Microsoft Azure?

Microsoft Azure is a leading cloud platform that lets you access the cloud services and resources provided by Microsoft. It provides various services, including computation, storage, analytics, and networking. It is used to deploy applications on the cloud.

What is the URL format for Azure Table Storage Account?

The URL format for Azure Table Storage Account is:

http://<storage account>.table.core.windows.net/<table>

The URL format for Azure Cosmos DB Table API accounts is:

http://<storage account>.table.cosmosdb.azure.com/<table>

What is an Azure Storage Account?

There are two ways to use Azure Table Storage. To provide access to Azure storage, an Azure Storage Account is necessary. To provide access to Azure Cosmos DB, it is necessary to have a Table API account.

What is an entity in Azure Table Storage?

An Entity is a record in a database. It is a set of properties. The size of an entity in Azure Storage can be up to 1 MB, and that in Azure Cosmos DB is 2 MB.

What is Table in Azure Table Storage?

You can create tables to store non-relational structured data within the Azure Storage Account. A user can create any number of tables. A Table in Azure Table Storage is schemaless, so not all records need to have the same properties.

Conclusion 🔚

This article discussed Azure Table Storage. We also discussed the structure of Azure Table Storage. To learn more about Microsoft Azure, visit Microsoft Azure - Coding Ninjas Coding Ninjas Studio.

I hope you would have gained a better understanding of these topics now!

Are you planning to ace the interviews of reputed product-based companies like AmazonGoogleMicrosoft, and more? 

Attempt our Online Mock Test Series on Coding Ninjas Studio now!

Happy Coding!

Topics covered
1.
Introduction 📃
2.
Azure Table Storage 📄📁
3.
Azure Table Storage Structure 
4.
Create an Azure Storage table in the Azure portal
5.
Frequently Asked Questions❔
5.1.
What is Microsoft Azure?
5.2.
What is the URL format for Azure Table Storage Account?
5.3.
What is an Azure Storage Account?
5.4.
What is an entity in Azure Table Storage?
5.5.
What is Table in Azure Table Storage?
6.
Conclusion 🔚