Possible Error in MB to TB Conversion in Synapse Cost Calculation: SynapseServerlessWorkbook

[DataBach-maker]

Hello team,

I have a question regarding the calculation in this line. Should it not be division by 1,000,000 to convert MB to Terabyte?

Below is the query copied from the KQL Query Mode. The issue would be these two lines:

| extend Approx_Accumulated_Cost=((TotalMBProcessed) * 5.0 / 100000.0) / 100 
| extend Approx_Cost_Per_Execution=((TotalMBProcessed) * 5.0 / 100000.0) / 100 / QueryCount

Full Query :

//Queries by completion type
SynapseBuiltinSqlPoolRequestsEnded
| where _ResourceId in~ ('/subscriptions/******')
| project 
    BytesProcessed=Properties.dataProcessedBytes,
    tostring(Identity),
    QueryHash=tostring(Properties.queryHash),
    QueryText=tostring(Properties.queryText),
    _ResourceId
| extend MbProcessed = case (
                           BytesProcessed < 10000000,
                           10000000,
                           BytesProcessed
                       ) / 1000 / 1000
| summarize 
    MaxSingleQueryMBProcessed=max(toint(MbProcessed)),
    TotalMBProcessed=sum(toint(MbProcessed)),
    QueryCount=count(),
    QueryHash=any(QueryHash),
    Resource=any(_ResourceId)
    by QueryText //using queryText because queryHash doesn’t change if only literals are different
| extend Approx_Accumulated_Cost=((TotalMBProcessed) * 5.0 / 100000.0) / 100 
| extend Approx_Cost_Per_Execution=((TotalMBProcessed) * 5.0 / 100000.0) / 100 / QueryCount
| order by TotalMBProcessed

Let me know if it was a mistake. I can contribute the fix if you like.

Thanks,

Ariane