BigQuery’s useful features
Having completed the exercise from the previous section, where we used BigQuery in a practical scenario where we were developing a data warehouse, in this last section of the chapter, let’s bring back our perspective to see BigQuery as a tool.
BigQuery is an integral tool in the GCP data engineering ecosystem, so even though BigQuery at its core is a database, on top of that, there are many more features, such as ones for machine learning, transferring data, and scheduling queries.
I will use this section to guide you quickly through the important additional BigQuery features that you might use in the future. As usual, I will focus on helping you narrow down what is important to you as a data engineer.
As a reminder, the best source for detailed information about each feature is the GCP public documentation. This book will only give a high-level description of features so that you can understand when certain features are relevant to...