question

FrancisS-4889 avatar image
FrancisS-4889 asked ·

Not getting proper Output of Stream Analytics job in storage account table

Hi, I am trying to capture data using event hub and the output of the stream analytics job is directed to a table in storage account where a 'record' column gets created alongwith some autogenerated timestamp columns. This record column contains only 'array' as value for all the records instead of actual data. Please help in this regards.

azure-storage-accountsazure-stream-analytics
1 comment
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

rocksde avatar image
rocksde answered ·

Hi,
Azure Storage Table doesn't support Array. You need to break them out in stream analytics like explained here https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parsing-json#array-data-types


1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@FrancisS-4889 Just checking in to see if the above answer helped. If this answers your query, please don’t forget to "Accept the answer" and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 · ·