Why You Should Use Azure Storage Tables
Рет қаралды 6,822
Күн бұрынTable Storage is often one of the most overlooked options on Azure for data storage, but it’s also one of the most versatile, scalable, and cheapest options there is. It provides a key-value pair storage mechanism that can scale to terabytes of data and a queryable API with OData. In this video, we’ll look at how it works and the tools and API’s for working with Table Storage.
00:00 -- Table Storage on Azure
08:46 -- Azure Portal and Storage Explorer
13:51 -- Using OData to Query Data
OData: www.odata.org/
------
Wintellect:
WintellectNOW: www.wintellectnow.com/
Blaize's Website: www.blaize.net/
Twitter:
Blaize: / theonemule
Wintellect: / wintellect
WintellectNOW: / wintellectnow
@emargee 2 жыл бұрын
Your videos are great, they deserve more views. I've been trying to find good cosmos db content, and have been working through your videos on that and the other ones (like this one). Thanks for the good info
@gothdawn1966 Жыл бұрын
This was a great find, as I was a little weary of finding content that tells you how to set these up, but not how to use them, thank you! I particularly like 'cheap data storage' mentioned at 07:57, which is primarily why I am looking at this. But does anyone know of any learning/videos that compares this solution with a small RDMBS (eg Azure SQL DB)....?
@osky7542 2 жыл бұрын
Very good explanation, congratulations. I have a doubt, if I want to use this type of tables, how can I delete all the content before inserting new rows?
@Atmosera- 2 жыл бұрын
You can do replace upserts with this. It removes then replaces all the data for a row.
@DickBakerSql 2 жыл бұрын
if you query by partitionkey (eg eq 'AK') that may invoke a single thread. Maybe querying by rowkey (eg eq '456') would involve many threads (perhaps one per partition) and reduce all results together. Perhaps quicker (if few but bug partitions). IMHO usual mantra "test, test, test" applies!
@DickBakerSql 2 жыл бұрын
for bug read big [sorry my fat fingers!]
@BlaizeStewart 2 жыл бұрын
Within a partition can be faster depending on the query. Going across partitions is generally something to avoid if possible. But yes! Test, test, test. And even when you are sure, test again
@lost_in_thoughts Жыл бұрын
How to sort the data in these tables based on any columns?
@Atmosera- Жыл бұрын
You really can't sort with this. You have to do it client side.
@silverpinecone Жыл бұрын
How do I copy these table data from one datalake to another datalake??
@Atmosera- Жыл бұрын
You'd need to wrote a script tp do that.
@nitinpandey4857 Жыл бұрын
Is there a way we can run stored functions or procs on them.?
@Atmosera- Жыл бұрын
There's no trigger for stables. If you want to use tables and create a trigger, use a storage queue to trigger a function that can read the table.
Adam Marczak - Azure for Everyone
Рет қаралды 91 М.
Windows, computers and Technology
Рет қаралды 221
Scott Duffy @ GetCloudSkills
Рет қаралды 29 М.
😍 Таких шикарных и гибких телевизоров, тем более за такую копеечную цену вы больше нигде не найдете.
Любимый WB
Рет қаралды 3,8 МЛН
Мой Компьютер
Рет қаралды 128 М.
Shark Zhan
Рет қаралды 9 МЛН