Implementing data warehousing solution in Google Cloud Using Big Query

Abstract

This study focused on assessing the effect of implementing a data warehousing solution in Google Cloud using BigQuery. This study shows the BigQuery architecture, which is based on the separation of storage and processing. The data is kept in a replicated, dependable, and distributed storage system, with elastic distributed compute nodes handling data input and processing. BigQuery proved to be a dependable, user-friendly, and customisable platform for extracting structured data from blockchains. The analysis yielded results in minutes to hours. BigQuery offers significant SQL capabilities, which will help the NY Mets or any other sports business to keep their secret information