Top

Google Cloud Knowledge Notes

Apr 01, 2021 | 1338 views

New Blog Series - BigQuery Explained: An Overview

https://medium.com/google-cloud/bigquery-explained-overview-357055ecfda3 


How I prepared for Google Cloud Certified - Associate Cloud Engineer Exam? [Simple and easy structure] https://rakeshvardan.hashnode.dev/how-i-prepared-for-google-cloud-certified-associate-cloud-engineer-exam   

How I Passed the Google Cloud Associate Engineer Certification?  https://medium.com/@charles_j/how-i-passed-the-google-cloud-associate-engineer-certification-63a0fd932057 


Take the Associate Cloud Engineer practice exam ( https://cloud.google.com/certification/practice-exam/cloud-engineer  ) one week before the Certification exam. So, you can analyze your knowledge and check where you stand.


--- BigQuery Use Cases ## Summarize cost statistic for some logs


select sum(size_in_MiB) as total_MiB, sum(cost) as total_cost_USD from
 (select table_id, 
         sum(size_bytes)/pow(10,6) as size_in_MiB, 
         sum(size_bytes)/(pow(10,9)*2) as cost 
     from `.__TABLES__` 
     where REGEXP_CONTAINS(table_id, r"_202103.*") 
group by table_id 
order by size_in_MiB desc)

BigQuery:



Leave a comment

0 comments