Azure IoT Hub - How to use Table Storage in IoT Hub?

3
votes

First of all, sorry for my english skill.

I'm a high school student from South Korea who's doing project with Azure IoT Hub.

I am working on a project where a raspberry pi device is sending values to an Azure IoT Hub. I would like to save this data in Azure Table Storage as this data will be used by some other services (Azure WebApp for example).

So I tried to save raspberry pi values in Azure Table Storage. But when I add endpoints of IoT Hub, I just can use only blob storage container

when i pick container

this is my storage created before, no any other setting, just default

when i choose, default is blob and i can't change endpoints to table storage.

of course i still don't understand about iot hub please don't look so bad.

In a nutshell

  1. I want to send raspberry pi values to Azure Table Storage and not Blob Storage however only option available to me is Blob Storage when I am setting endpoints for Azure IoT Hub.
  2. How to send values to Table Storage via Azure IoT Hub.

by any chance, my logic for Azure is completely wrong?

3
azureazure-storageazure-table-storageazure-iot-hubazure-blob-storage
Good Morning DolXeGoD, did you find a way to send your IoT data direct into a table storage? For visualization I want to use PowerBI but a query from BlobStorage takes PowerBI huge time. I speak from around one hour for 3MB and that is not acceptable. thank you for your respond, best wishes from Austria, Markus – Maxcel

3 Answers

1
votes

Simple way how to store D2C messages in the Azure Store Table is using an Azure EventHubTrigger Function.

More details about the function and its integration with Azure IoT Hub can be found here.

2
votes

IoT Hub natively supports routing messages to Azure storage as blobs. Refer Save IoT hub messages that contain sensor data to your Azure blob storage. There does, however, seem to be a typo in the doc where it lists ‘table storage’ instead of 'blob storage'. We’ll get those typos corrected.

2
votes

You can use either functions or Azure Stream Analytics to push hub data to Azure table storage. I found Stream Analytics worked best for me as I was better able to format the data.