COGS
Overview
COGS dataset contains the overall, processing and storage COGS values of the MSAI Data Platform and Scorecard jobs and streamset.
Basic Information
Data Latency: T-1Day
Freshness: Daily Refresh
Upstream Data Source: SOTEL Insights Data
Data StartTime: October 2, 2021
Data Retention: No Expiration
Data Content: Calculated cost of StorageInfo and ProcessingInfo.
Columns
| Column Name | Data Type | Description | Sample Value | IsNullable |
|---|---|---|---|---|
| Date | datetime | Date of the StorageInfo and ProcessingInfo | 2022-03-14 00:00:00.000 | False |
| PhysicalSizeTiB | decimal(18,2) | Sum PhysicalSizeTiB of the StorageInfo by Date | 14587.96 | True |
| StorageCost | decimal(18,2) | Calculate StorageCost according to PhysicalSizeTiB | 229.81 | True |
| DailyCostToken | decimal(18,2) | Sum CostToken of the ProcessingInfo by Date | 3777.00 | True |
| ProcessingCost | decimal(18,2) | Calculate ProcessingCost according to DailyCostToken | 1956.00 | True |
| TotalCost | decimal(18,2) | Sum StorageCost and ProcessingCost | 2185.81 | True |
Usage
Sample Scripts
Find Daily data of the COGS,as input or output
select
Date,
PhysicalSizeTiB,
StorageCost,
DailyCostToken,
ProcessingCost,
TotalCost
from COGS
where Date >= '2022-03-01' and Date <= '2022-03-05'
Sample Data
| Date | PhysicalSizeTiB | StorageCost | DailyCostToken | ProcessingCost | TotalCost |
|---|---|---|---|---|---|
| 2022-03-01 00:00:00.000 | 14644.64 | 230.70 | 6959.00 | 3603.00 | 3833.70 |
| 2022-03-02 00:00:00.000 | 14059.13 | 221.48 | 7853.00 | 4066.00 | 4287.48 |
| 2022-03-03 00:00:00.000 | 14332.80 | 225.79 | 7111.00 | 3682.00 | 3907.79 |
| 2022-03-04 00:00:00.000 | 14186.66 | 223.49 | 7431.00 | 3848.00 | 4071.49 |
| 2022-03-05 00:00:00.000 | 14179.68 | 223.38 | 6311.00 | 3268.00 | 3491.38 |