Calculate costs for capacity Pricing model, doubt about slots data source

[DianaCastro314]

I’m using BigQuery Editions and running on a Capacity Pricing model (Enterprise and no commitments). So, my formula would be slot milliseconds / (1000 * 60 * 60) * $0.06. But I have doubts about the source to get slots for the formula.

I have differences when querying INFORMATION_SCHEMA.JOBS_TIMELINE and INFORMATION_SCHEMA.JOBS, the first one in some jobs give me more slots than the second one. Reading documentation for costs mostly posts uses INFORMATION_SCHEMA.JOBS, but for me INFORMATION_SCHEMA.JOBS_TIMELINE shows me the exact slots that Capacity Management (slots adminitration) shows.

So, whats the source of true for costs? why those sources shows differences in slots by job? and, if both are at job level is there any way to move from INFORMATION_SCHEMA.JOBS_TIMELINE slots to INFORMATION_SCHEMA.JOBS slots?

[caryna]

Hi @DianaCastro314 ,

Welcome to the Google Cloud Community!

Both schemas offer valuable insights:

• INFORMATION_SCHEMA.JOBS provides a summary of completed jobs, including the estimated slot usage.
• INFORMATION_SCHEMA.JOBS_TIMELINE offers a more granular view of slot usage, showing near real-time data for each second of job execution.

The formula you provided pertains specifically applies only to the average slot utilization calculation for individual jobs:

@DianaCastro314

slot milliseconds / (1000 * 60 * 60) * $0.06

Unfortunately, you cannot transfer slots between JOBS_TIMELINE and JOBS.

@DianaCastro314

if both are at job level is there any way to move from INFORMATION_SCHEMA.JOBS_TIMELINE slots to INFORMATION_SCHEMA.JOBS slots

For a more comprehensive analysis, INFORMATION_SCHEMA.JOBS_TIMELINE is recommended, as it delivers a detailed breakdown of job execution over smaller intervals (typically seconds).

I hope the above information is helpful.