Azure Table Storage Tutorial | Easy and scalable NoSQL database
ฝัง
- เผยแพร่เมื่อ 10 ก.ค. 2024
- 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 - วิทยาศาสตร์และเทคโนโลยี
In my opinion, this is a short, straightforward, to-the-point, clear explanation of how to use Azure Table. Thank you.
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.
¡Thanks Adam! I saw several videos explaining this, but yours is the most clear and well explained.
Thanks Adam, your videos help us understand concepts in simple and better way!
Thanks Adam, Tons of thanks for you. your videos are the absolute best resource for understanding azure tables that exists.
This is awesome. I was looking to understand what Table Storage is all about and now I feel ready to leverage it. Thanks Adam!
My pleasure! Thank you for the kind words ;)
Amazing Video - Greatly helped me with my College Project
AMAZING!
Absolutely brilliant and fabulously well done - Thank you and greetings from Sweden!
Thank you! Cheers Marcus! Greetings from Poland :)
Thank You Adam. Loved this Video
Thanks, always a fan of your tutorial
thanks a lot - very clear and helpful to get the picture on this topic
I was waiting for this video.. thanks Adam..
Thanks! Enjoy!
Great!! Worked like a charm for me.
Great!
Thanks Adam, Nice content, well explained.
My pleasure!
Thanks for the video. Your video is really good. Keep creating such videos, it really helps.
Thank you, I will
Very nice, thank you Adam!
Thanks for listening :)
Adam, toto je super, ďakujem.
Thanks, prosze bardzo! :)
Thank you Adam for the detailed demo... This really helps !
My pleasure!
@@AdamMarczakYT Do you have an example on how to do this from an Azure Function ? is it Similar ?
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
Awesome video thank you Adam!!
Cheers Jimmy! :)
Thank you Adam.
Thnaks for sharing your knowledge
Thank you, enjoy!
Really good video
Glad you think so!
Good teaching,
Thanks!
nice video :) I like it
Thanks!
Thanks for this wonderful tutorial. Can you please tell how can I enter a new line in string type?
Dzięki!
Prosze! :)
we need more to c# azure videos.
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.
That is correct :) thanks!
Can you explain how to create a pipeline to load data of a csv/excel file to azure table storage?
Hi Adam Marczak.. could you please provide a video like how to read azure table storage data using Dataflows in ADF
Can we connect to Table storage and query data using ADF
Could you please make video on how implement CRUD operation on Table storage accounts using Azure managed identity(Azure.Data.tables)
How can I store files( like pdf, img, .doc etc.) in azure table by react?
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?)
Booleans are supported by default. Just use SDK and make class definitions.
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 ?
Hey thanks. There is demo like that in the video using logic apps and table trigger.
@@AdamMarczakYT Thanks for reply...I found videos SQL server or other databases but didn't find any videos with Blob Table.
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.
How can i update for multiple row key in azure logic apps
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.
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.
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.
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.
Great tutorial! I dont understand why we need the Powershell. Could you please explain?
Thanks. Please explain why do you think you need PowerShell?
@@AdamMarczakYT I dont know, I didnt really understand when we need it
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?
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!
Thank you sir
Thanks for the response. Please upload the azure active directory part and Virtual network part as well thanks
Hi Adam, Thanks for the content.Please also provide the scripts, so that we can test on our side also.
Thanks,
Best of Luck
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!
dot net part are hard to digest for non-programmer.
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 😊
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
Can you please help me with the code. How to download container logs based on yyyy/mm/DD and convert it into CSV file.
I think there seems to be misunderstanding here as to what container is in this case. What is container according to you?
@@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.
Great Vvideo, Could you please tell me how the data will be inserted by using application
Hey, thanks! I'm not sure I understood, can you elaborate on your quetion?
I am not able to expand the table to edit the entity. Any help will be appreciated
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.
Probably either as a Parquet/Delta tables on Data Lake and/or Synapse Analytics
is it not possible to just upload csv to a table storage?
You can using Azure Data Factory.
Can we use table storage to display in tableau ?
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.
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.
Maybe in the future :) Thanks for the suggestion!
@@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.
hey can anyone tell me how can i connect my bot to an existing sql database?
how is this related to table storage video?
We need new video because the table looks very different in the new version of Microsoft Azure
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.
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 :)
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!
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.
"TH-cam"
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
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!
you go too fast, too fast... paste here, paste there.. it could be muuuuuuch more useful if you did all steps one by one, slower. such a pity
noted!
Dude, you can set playback speed in settings.