Sql syntax reference

https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax

functions reference

https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators

best practices next talk

https://www.youtube.com/watch?v=ZVgt1-LfWW4

query optimization

https://cloud.google.com/bigquery/docs/best-practices-performance-compute

clustering and partitioning

https://cloud.google.com/bigquery/docs/clustered-tables

Query plan like explain statement

https://cloud.google.com/bigquery/docs/query-plan-explanation

Detailed use-case articles

  1. https://medium.com/teads-engineering/give-meaning-to-100-billion-analytics-events-a-day-d6ba09aa8f44
  2. https://medium.com/teads-engineering/managing-a-bigquery-data-warehouse-at-scale-e6ec9a8406b2

Model training in BigQuery

cli snippets

BigQuery SQL Snippets