BigQuery Automation Exports via Email

Google Drive Link

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.