bigquery-oreilly-book
Source code accompanying:
|
BigQuery: The Definitive Guide by Valliappa Lakshmanan and Jordan Tigani O'Reilly, Nov 2019 |
Buy on Amazon | Read online on Safari |
After June 2020
Articles that update parts of the book
- Remote Functions in BigQuery
- Working with JSON data in BigQuery
- An Agile Architecture for Analytics and AI on Google Cloud
- Explaining a BigQuery ML model
- Anomaly detection in time series data using BigQuery ML
- Hyperparameter tuning BigQuery ML: BigQuery ML can use Vertex AI to tune common model parameters
- Quickly create BigQuery demo/dev environments using SQL
- PIVOT in BigQuery
- Speeding up small queries in BigQuery with BI Engine
- How to Trigger Cloud Run Actions on BigQuery Events
- Loading complex CSV files into BigQuery using Google Sheets
- Building SQL pipelines in BigQuery with Dataform
- Validating successful execution of BigQuery scripts using ASSERT
- RANGE_BUCKET
- How to right-size your flat-rate and flex slots reservations in BigQuery
- How to do text similarity search and document clustering in BigQuery
- Trying out Data QnA on BigQuery and Google Sheets
- How to load XML data into BigQuery using Python Dataflow
- The best of both worlds: Calling Auto ML from BigQuery
- Loading and transforming data into BigQuery using dbt
January 2020 to June 2020
Articles that update parts of the book, and incorporated into text in June 12, 2020 edition.
- Integration between TensorFlow 2.0 and BigQuery
- How to query geographic raster data in BigQuery efficiently
- Backing up and restoring a BigQuery table/view/dataset
- How to copy a BigQuery dataset from one region to another
- Training a recommendation model for Google Analytics data using BigQuery ML
- Using BigQuery (and BigQuery ML) from Kubeflow Pipelines
- Displaying BigQuery results on Google Maps using Data Studio
- Using BigQuery Flex Slots to run machine learning workloads more efficiently
- How to export a BigQuery ML model and deploy it for online prediction