Learning Google BigQuery

Summary

This chapter covered the basics of using SQL in BigQuery. BigQuery provides a simple and intuitive interface, and the use of the standard SQL dialect provides a level of standardization across other database management systems. The validation features of the interface are not only useful, but are also somewhat rare (at least rare for most integrated development environments for SQL). BigQuery functions are powerful, but are also familiar to any developer with SQL experience. Lastly, most administration tasks can be performed with ease through the use of BigQuery's interface or via the standard SQL language.