Azure Table Storage Tutorial | Easy and scalable NoSQL database

Рет қаралды 89,777

Күн бұрын

Do you need simple but scalable NoSQL database in a cloud? Look no further, with Azure Table Storage you can create applications extremely easy while maintaining all the best features of Storage Accounts like geo-replication, security, scalability, high availability and low price. Join me for quick introduction video.
In this episode I give you introduction to what Table Queue service is. How can you provision it, what are the typical scenarios that you would want to leverage its capabilities.
Code sample: github.com/MarczakIO/azure4ev...
In this episodes live demo of
- Creating table storage
- Managing table and its data
- Working with Table Storage using Logic Apps
- Working with Table Storage using PowerShell
- Working with Table Storage using .NET
Next steps for you after watching the video
1. What is azure table service
- docs.microsoft.com/en-us/azur...
2. Table Storage or Cosmos Db Table API
- docs.microsoft.com/en-us/azur...
3. Design guide for Table Storage
- docs.microsoft.com/en-us/azur...
Want to connect?
- Blog marczak.io/
- Twitter / marczakio
- Facebook / marczakio
- LinkedIn / adam-marczak
- Site azure4everyone.com

Пікірлер: 100

@mkolus 2 жыл бұрын

¡Thanks Adam! I saw several videos explaining this, but yours is the most clear and well explained.

@mangesh2215 2 жыл бұрын

Thanks Adam, your videos help us understand concepts in simple and better way!

@hexatorus5452 2 жыл бұрын

Thank you. This was so clear and easy to understand. I've been looking for half a day now for Azure table storage information and this was by far the absolute best resource for understanding azure tables that exists.

@appma26 2 жыл бұрын

In my opinion, this is a short, straightforward, to-the-point, clear explanation of how to use Azure Table. Thank you.

@sivaram2512 2 жыл бұрын

Thanks Adam, Tons of thanks for you. your videos are the absolute best resource for understanding azure tables that exists.

@jesus21282 3 жыл бұрын

This is awesome. I was looking to understand what Table Storage is all about and now I feel ready to leverage it. Thanks Adam!

@AdamMarczakYT 3 жыл бұрын

My pleasure! Thank you for the kind words ;)

@marcusjansson6586 3 жыл бұрын

Absolutely brilliant and fabulously well done - Thank you and greetings from Sweden!

@AdamMarczakYT 3 жыл бұрын

Thank you! Cheers Marcus! Greetings from Poland :)

@angelotraverso9455 Жыл бұрын

Amazing Video - Greatly helped me with my College Project AMAZING!

@krishnakuraku6853 4 жыл бұрын

I was waiting for this video.. thanks Adam..

@AdamMarczakYT 4 жыл бұрын

Thanks! Enjoy!

@ravindranraghu Жыл бұрын

Thank You Adam. Loved this Video

@rodrigomgsys 3 жыл бұрын

Great!! Worked like a charm for me.

@AdamMarczakYT 3 жыл бұрын

Great!

@jizhang75 Жыл бұрын

Thanks, always a fan of your tutorial

@thomascziesla3768 2 жыл бұрын

thanks a lot - very clear and helpful to get the picture on this topic

@moeejtamboli3157 3 жыл бұрын

Thanks for the video. Your video is really good. Keep creating such videos, it really helps.

@AdamMarczakYT 3 жыл бұрын

Thank you, I will

@meghnakharera253 4 жыл бұрын

Thanks Adam, Nice content, well explained.

@AdamMarczakYT 4 жыл бұрын

My pleasure!

@ChuckJonkman 4 жыл бұрын

Very nice, thank you Adam!

@AdamMarczakYT 4 жыл бұрын

Thanks for listening :)

@michalbolehradsky9709 3 жыл бұрын

Adam, toto je super, ďakujem.

@AdamMarczakYT 3 жыл бұрын

Thanks, prosze bardzo! :)

@sibymathew1802 4 жыл бұрын

Thank you Adam for the detailed demo... This really helps !

@AdamMarczakYT 4 жыл бұрын

My pleasure!

@sibymathew1802 4 жыл бұрын

@@AdamMarczakYT Do you have an example on how to do this from an Azure Function ? is it Similar ?

@sibymathew1802 4 жыл бұрын

Answering my own question. From Azure Functions its much easier by configuring an output binding : docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-storage-table?tabs=csharp-script

@jimmythompson9677 4 жыл бұрын

Awesome video thank you Adam!!

@AdamMarczakYT 4 жыл бұрын

Cheers Jimmy! :)

@Info-Galaxy 2 жыл бұрын

Thank you Adam.

@animecharacter5866 4 жыл бұрын

Thnaks for sharing your knowledge

@AdamMarczakYT 4 жыл бұрын

Thank you, enjoy!

@geogyzachariah5849 3 жыл бұрын

Really good video

@AdamMarczakYT 3 жыл бұрын

Glad you think so!

@VetriJ 4 жыл бұрын

Good teaching,

@AdamMarczakYT 4 жыл бұрын

Thanks!

@xoxoo4877 3 жыл бұрын

nice video :) I like it

@AdamMarczakYT 3 жыл бұрын

Thanks!

@Jakobowsky 3 жыл бұрын

Dzięki!

@AdamMarczakYT 3 жыл бұрын

Prosze! :)

@toshikmehta8701 2 жыл бұрын

Thanks for this wonderful tutorial. Can you please tell how can I enter a new line in string type?

@aashwinstudio8649 2 жыл бұрын

we need more to c# azure videos.

@MikeBaron2009 4 жыл бұрын

Thank you, that is great video, I assume the Azure Data Factory can be used to load text files with different structure to the table.

@AdamMarczakYT 4 жыл бұрын

That is correct :) thanks!

@meghnachowdhury8526 Жыл бұрын

Can you explain how to create a pipeline to load data of a csv/excel file to azure table storage?

@vivek.padale 4 жыл бұрын

Hi Adam, Thanks for the content.Please also provide the scripts, so that we can test on our side also. Thanks, Best of Luck

@AdamMarczakYT 4 жыл бұрын

Updated! Here is the link. Added to video description too as it was missing github.com/MarczakIO/azure4everyone-samples/tree/master/azure-tablestorage-introduction thanks for watching!

@pbhaskar5197 Жыл бұрын

Hi Adam Marczak.. could you please provide a video like how to read azure table storage data using Dataflows in ADF

@health40plus 4 жыл бұрын

I am very much fortunate....I was working on assignment which is regarding Blob Table just got notification of this video...Thanks a lot brother... I have one question...I want to create Logic app where I want to read last row from Blob Table. But I didn't find trigger with Blob Table...my question is can we create event trigger on Blob Table ??? please tell me how to do it ?

@AdamMarczakYT 4 жыл бұрын

Hey thanks. There is demo like that in the video using logic apps and table trigger.

@health40plus 4 жыл бұрын

@@AdamMarczakYT Thanks for reply...I found videos SQL server or other databases but didn't find any videos with Blob Table.

@AdamMarczakYT 4 жыл бұрын

There is no service in Azure called Blob Table, it's either Blob Storage which is for files and Table Storage which is tabular entities with rows of data. Both have trigger in logic app going by their names.

@prudhvim2691 3 жыл бұрын

Hi Adam, can you please help me with this - how to change data type to "Boolean" in the insert statement of a row (by default it is taking as String right?)

@AdamMarczakYT 3 жыл бұрын

Booleans are supported by default. Just use SDK and make class definitions.

@Jasmika4122 10 ай бұрын

Could you please make video on how implement CRUD operation on Table storage accounts using Azure managed identity(Azure.Data.tables)

@9322015328 4 жыл бұрын

Hey Adam Hope you are doing well!! Can you please let us know , how to show errors in table storage while we insert invalid data into a table.

@AdamMarczakYT 4 жыл бұрын

Hey, thanks, I'm doing well! Can you clarify, what kind of error do you mean? If you are programming in .NET you will see normal exception in the code. Thanks for watching.

@sathireddy6562 4 жыл бұрын

Great Vvideo, Could you please tell me how the data will be inserted by using application

@AdamMarczakYT 4 жыл бұрын

Hey, thanks! I'm not sure I understood, can you elaborate on your quetion?

@Atim86 3 жыл бұрын

I am not able to expand the table to edit the entity. Any help will be appreciated

@ivannaivanova3623 3 жыл бұрын

Great tutorial! I dont understand why we need the Powershell. Could you please explain?

@AdamMarczakYT 3 жыл бұрын

Thanks. Please explain why do you think you need PowerShell?

@ivannaivanova3623 3 жыл бұрын

@@AdamMarczakYT I dont know, I didnt really understand when we need it

@abhikn9688 4 жыл бұрын

Hi sir Awesome video. Once we upload the file or image in storage account how we need to get the data we need to Ryt any quires to get the data?

@AdamMarczakYT 4 жыл бұрын

Hey, you use BLOB for files/images but TABLE storage for table/row data. You can query the table but not files at this time. You would need to load contents of the file to table storage using something like data factory. Thanks for watching!

@abhikn9688 4 жыл бұрын

Thank you sir Thanks for the response. Please upload the azure active directory part and Virtual network part as well thanks

@fernandoglezcastillo9199 4 жыл бұрын

Hi, I'm having trouble installing the NuGet Microsoft.Azure.Cosmos.Table with Visual Studio 2017, using FrameWork 4.8. Could you tell me what FrameWork is needed? Thank you.

@AdamMarczakYT 4 жыл бұрын

Hey, hard to say without seeing the error message. In general this library is designed for both .NET standard and .NET framework. But just in case you can try using www.nuget.org/packages/WindowsAzure.Storage instead as it is older version.

@user-hu9js6mx8b Жыл бұрын

Can we connect to Table storage and query data using ADF

@sushmas3864 3 жыл бұрын

Great video.. How can we download IIS/ Blog logs from the container based on yyyy/mm/dd using powershell. Can you please guide. It will be helpful 😊

@AdamMarczakYT 3 жыл бұрын

If you save it using yyyy/mm/dd as path you can use prefix filter like here docs.microsoft.com/en-us/powershell/module/azure.storage/get-azurestorageblob?view=azurermps-6.13.0&WT.mc_id=AZ-MVP-5003556#example-3--get-blobs-by-name-prefix

@sushmas3864 3 жыл бұрын

Can you please help me with the code. How to download container logs based on yyyy/mm/DD and convert it into CSV file.

@AdamMarczakYT 3 жыл бұрын

I think there seems to be misunderstanding here as to what container is in this case. What is container according to you?

@sushmas3864 3 жыл бұрын

@@AdamMarczakYT Hi Adam. Thank you for the response. I mean blob logs ( which is use to store the web app log details/ IIS Logs) in my case.

@rahulsrivastava2341 Жыл бұрын

How can I store files( like pdf, img, .doc etc.) in azure table by react?

@krishnamurthy9720 2 жыл бұрын

How can i update for multiple row key in azure logic apps

@puspraj4687 3 жыл бұрын

are we going to see any video on how to USE Azure services using REST APIs, for example using REST APIs for manipulating data of a Table storage.

@AdamMarczakYT 3 жыл бұрын

Maybe in the future :) Thanks for the suggestion!

@puspraj4687 3 жыл бұрын

@@AdamMarczakYT thanks adam, that would be very useful. Also I went through many MS docs on using SharedKey and Azure AD authentication for getting tokens and calling REST APIs for different azure services. Although I got to know how to get Bearer token but I was not aware how to use that token for accessing different Azure services.

@mohammodkayum5450 3 жыл бұрын

Hi sir i need to store 10 table contain almost 20 TB of data. we have 5% read and 95% write on that table . Mostly inserting record daily . what is the best and cheapest solution to store that table. Thanks in advance for your help.

@AdamMarczakYT 3 жыл бұрын

Probably either as a Parquet/Delta tables on Data Lake and/or Synapse Analytics

@jgowrri 4 жыл бұрын

Can we use table storage to display in tableau ?

@AdamMarczakYT 4 жыл бұрын

I'm not certain. I'm not a Tableau expert. I would probably ask on their forums, as far as I remember there was no connector in the past but maybe that has changed.

@JohnJohnson-qu2os 4 жыл бұрын

is it not possible to just upload csv to a table storage?

@AdamMarczakYT 4 жыл бұрын

You can using Azure Data Factory.

@sammail96 8 күн бұрын

dot net part are hard to digest for non-programmer.

@zzaudeean 7 ай бұрын

We need new video because the table looks very different in the new version of Microsoft Azure

@ShanmukhGudivadaGamingGeek44 4 жыл бұрын

hey can anyone tell me how can i connect my bot to an existing sql database?

@AdamMarczakYT 4 жыл бұрын

how is this related to table storage video?

@bwzffgh7 Жыл бұрын

Do this and this and this, this, this, this, this, and these 8 things. Type in this and this and this and this and that and then open this screen and type in this. Now open AZ Shell and wait 5 minutes for it to open even though in my video it took 2 seconds. And watch me paste in this and this and this and this and this and this and this and this and this and this, this, this, and this, all of which I had fully typed out in notepad on my other screen that you can't see. Oh, and simply through in the word "simply" between every 4th sentence, to make it look like this stuff is super simple and you already have all these steps and the PowerShell scripts that you've never seen before completely memorized. "KZfaq"

@robertotomas 4 жыл бұрын

I dont feel like this (or very many other resources) does a good job of describing partition and row keys. I think Microsoft is to blame here, the first thing you see when you create a table are these fields... this tempts people to set them before considering the data. This is what you did in the video, and it is _exactly the opposite_ of what a DBA would do.

@AdamMarczakYT 4 жыл бұрын

Hey Roberto, in general of course you are correct, you should always consider your data. For the video I already knew my data hence, I knew what partition keys/rows keys I wanted to use. This is also very simple NoSQL since you can't make primary keys you need to be clever how you design parition/row keys depending on scale you plan to use and how will you query your data. This document does a good job at this, feel free to check it out. docs.microsoft.com/en-us/rest/api/storageservices/designing-a-scalable-partitioning-strategy-for-azure-table-storage Thanks for watching and commenting :)

@AdamMarczakYT 4 жыл бұрын

Just wanted to add, this video wasn't focused on the modeling topic for partition/row keys because I plan to have separate video purely for this topic as there are couple of popular techniques here. It's not a single approach to data, it depends on how services will consume this data. There are cool techniques which allow you to grab latest row based on the key without need to order, this is very important for serverless if you design for speed. Well, a topic for another day for sure! Thanks for stopping by again!

@syedalikhan5173 4 жыл бұрын

Hi Adam, Thanks a lot for sharing such a video. As I can see you are very good in power shell. I have a requirement wherein I have to create vms from image using powershell script. your help is highly appreciated. I can provide you my email id

@AdamMarczakYT 4 жыл бұрын

Thanks for watching, glad you enjoyed it. Unfortunately I can't help you with your coding tasks, I'm cure you will get it right though. There is a a lot of materials available. Best of luck!