BigQuery Automation Export via Email
Pham, Hy (2022)
Pham, Hy
2022
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2022120526305
https://urn.fi/URN:NBN:fi:amk-2022120526305
Tiivistelmä
Many clients of Google Cloud choose to export their billing data which contains price data, usage and cost estimates to CSV or JSON files straight from the supported billing export tool. This allows them to do future monitoring and forecasting. Google Cloud Platform (GCP) offered this capability to its clients as default; however, Google no longer provides this service.
This thesis offers guideline how to implement an alternative solution, which will be presented as a stand-alone Terraform module in the GCP Landing Zone.
The thesis describes the process of how to leverage other export billing data to BigQuery (BQ) feature. Other popular GCP services such as Cloud Functions, Pub/Sub, Cloud Storage, third-party mail server SendGrid, and Infrastructure as Code Terraform are also discussed. These tools can be used to build the automated billing data export solution for the case company clients as well as others, including the FinOps team, Architect, and DevOps team managers.
This thesis offers guideline how to implement an alternative solution, which will be presented as a stand-alone Terraform module in the GCP Landing Zone.
The thesis describes the process of how to leverage other export billing data to BigQuery (BQ) feature. Other popular GCP services such as Cloud Functions, Pub/Sub, Cloud Storage, third-party mail server SendGrid, and Infrastructure as Code Terraform are also discussed. These tools can be used to build the automated billing data export solution for the case company clients as well as others, including the FinOps team, Architect, and DevOps team managers.