YALineo
EN
Install

The calculation method.

For every figure, YALineo shows where it comes from. Here is the full method, formula by formula, with the official Databricks and Microsoft sources it rests on. The extension's "How it is calculated" links lead here.

  • Observed

    Read from the billing system tables, at the list price in force, with the join of Databricks' official example.

  • Allocated

    Shared among tables run by run, or hour by hour for a SQL warehouse, by published rules; the precision is shown next to every cost.

  • Estimated or potential

    Projections, the Calculator and savings to confirm, always flagged as such, with their assumptions and their step-by-step calculation.

  • Verifiable

    "Why?" gives the reason for a zero or missing cost, and a reconciliation SQL query returns the same total as YALineo, in your own workspace.

An identity, to the cent.

For the whole platform, the period's spend breaks down with nothing left over (section 5.6). The unattributed part is never forced to zero. On the extension's example platform, 90 days:

total spend
$12,535.00
Σ refresh(T)
$9,734.00
Σ read(T)
$884.40
tables off the map
$0.00
capacity with no query
$160.80
unattributed
$1,755.80

Every table cost shows its precision.

The rule that allocated it, from the surest to the least sure (section 5.7). A table takes the least sure label among its parts.

Surest

  1. billedBilled to this table by Databricks: a materialized view or a serverless streaming table.
  2. single tableThe only table written by the runs linked to it: their whole cost is its own.
  3. compute timeA run that writes several tables: its cost is shared by the compute time of the queries writing each.
  4. even splitA run that writes several tables without a compute time for all of them: equal shares.
  5. warehouseA share of a SQL warehouse, hour by hour, by the compute time of that hour's queries.
  6. periodNo run linked to the lineage: the cost is shared among the tables written over the period. The least sure rule.

Least sure