Main Menu

• 1-2 Overview
• 3 Dataset and Table Creation
• 4 Using BigQuery Dashboard Options
• 5 Efficient Schema Design in BigQuery
• 6 Operations on Datasets & Tables
• 7 Execution Plan of BigQuery
• 8 Partitioned Tables in BigQuery
• 9 Clustered Tables in BigQuery
• 10 Loading and Querying External Data Sources
• 11 Views in BigQuery
• 12 Materialized Views in BigQuery
• 13 BigQuery Command Line

Table Joins

Table JOIN Examples

SELECT 
  member.*, group.* 
FROM
 `proj.ds.members` as member
JOIN
 `proj.ds.groups` as group
ON
 member.group_id=group.group_id
WHERE
 group.group_id=5