CODEWITHSUNDEEP
google-bigquerygoogle-cloud-platform
Joe Scotto
Joe Scotto

Reputation: 10877

BigQuery detailed charges just shows how much data was analyzed

I'm trying to find out what is causing my BigQuery bill to be so high but when I click View Detailed Charges on Google Cloud I just get how much data was analyzed and how much it costs. Is there a place where I can view a detailed breakdown of what jobs cost so much and what is causing the bill to get so large?

Upvotes: 0

Views: 199

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172993

Is there a place where I can view a detailed breakdown of what jobs cost so much and what is causing the bill to get so large?

You should be able to use Jobs.list API to lists all jobs that you started in the specified project. Job information is available for a six month period after creation. The job list is sorted in reverse chronological order, by job creation time. Requires the Can View project role, or the Is Owner project role if you set the allUsers property

You actually can even make it without any coding - https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/list#try-it

Collect all you jobs info and analyse it as you wish

For the long term solution - you can either automate above process or use BigQuery Monitoring using Stackdriver

Upvotes: 3

Related Questions