Summary

In this chapter, we've learned the main aspects of the BigQuery syntax. After the creation of a dataset, we've discovered how to create tables, insert records, and read the rows stored in a table. You've also learned how to update existing records and how to remove rows and delete objects that are no longer useful, such as tables and views.

Completing the overview of the BigQuery SQL syntax, we dived into the main stages of the life cycle of an ML model. The three main phases to realize a use case are the creation, the evaluation, and the use of the ML model. For the training phase, we have found out how to train and create a new model using SQL. After that, we went through all the functions that can be used to monitor the effectiveness of a trained model, evaluating its key performance indicators. Finally, we saw how to use a trained model on a new dataset to infer the results and get predictions, forecasts, or recommendations. At the end of the chapter,...