BigQuery
BigQuery is a fully managed, serverless analytics service. It can scale to petabytes of data and is ideal for data warehouse workloads. It is the analysis stage of our solution, and once Dataflow processes our data, BigQuery will provide value to our business by querying large volumes of data in a very short period. Queries are executed in the SQL language, so it will be easy to use for many. We should emphasize that BigQuery is enterprise-scale and can perform large SQL queries extremely fast – all without the need for us to provision any underlying infrastructure.
Exam Tip
BigQuery is ideal for data warehouse workloads as it has the capacity for PB of storage.
BigQuery features
In this section, we will take a look at datasets and tables. These are two important concepts of BigQuery, and we need to understand them to be successful in the exam.
Datasets
Datasets are used to organize and control access to tables and views. We require at least one dataset...
