Event Hub Azure Stream Analytics size of record

Sara, VK 1

I have some messages in Event Hub, and I want to determine the size of the message in bytes

Thought I can do it in Azure Stream Analytics query

SELECT
t.metadata, t.payload, datalength(???? ) As SizeInBytes
INTO
[OutputAlias]
FROM
"my-e-h" t

the datatype of column is Record or RecordN. key value pairs
https://learn.microsoft.com/en-us/stream-analytics-query/data-types-azure-stream-analytics

How can I find the size, as the expected datatype for datalength is varbinary(max)'

Is there a OOTB way to find my event hub message size ?

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2021-05-17T17:35:42.867+00:00

Hello @Sara, VK ,
Thanks for the ask and using the Microsoft Q&A platform .
We reached out to the Eventhub team to check if they have anyway to check the size , they did confirmed that there is NO Api to get the message sze .

Thanks
Himanshu
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2021-05-18T22:31:47.803+00:00

Hello @Sara, VK ,
Thanks for the patience , unfortunately we are not getting the kind of response from the stream analytics team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.

Thanks
Himanshu
Himanshu Sinha 11 Reputation points

2021-05-25T15:21:47.597+00:00

Hello @@Sara, VK ,
We haven’t received any email from you as requested in the last response and was just checking back to see if you have a resolution.In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, please respond back with the more details as requested and we will try to help .
Thanks
Himanshu