About techGeek

I am using BigQuery to get GCP usage data using queries. I have a single query to get all details from GCP exported Bill data to BigQuery. select sum(cost) as cost, sum(credits.amount) as credit FROM `TABLENAME`LEFT JOIN UNNEST(credits) AS creditsWHE...

02-13-2024

Stackoverflow linkI am using Java SDK jars for BigQuery data fetching. From BigQuery I am fetching a detailed Usage Cost report for Invoice month. In my account, there are more resources so the Bill value is also high. The total rows present in the B...

Are these AI-generated queries? FYI: i tried all of those before posting it in the community

Getting error for this query : Name credit_amount not found inside credits at [69:45]I have one more doubt about the WITH aggregated_credits part, in this group by is done at billing_account_id, service_id, sku_id, and usage_date level. whether the r...

Thanks for the response.I tried the above query. with this I am getting correct cost value but credit amount is higher. Actual credit amount (-9973) but I got (-24660).Also In the above query credits.id, credits.type, credits.name, credits.full_name ...

02-19-2024

Hi @ms4446 , thanks for the response. I cannot fetch data by day or weekly because of some value mismatches. Is there any way to identify if a temporary table exists and if it does not exist query from the main table?

My Stats

Mafesa's Bio

Badges techGeek Earned

Recent Activity

Getting cost value mismatch while using UNNEST(credits) in BigQuery

Getting Table Not found Exception

Re: Getting cost value mismatch while using UNNEST(credits) in BigQuery

Re: Getting cost value mismatch while using UNNEST(credits) in BigQuery

Re: Getting cost value mismatch while using UNNEST(credits) in BigQuery

Re: Getting Table Not found Exception