Learning Google BigQuery

Joining tables in BigQuery

In order to create the most efficient database, many analysts and administrators will warehouse data in multiple tables. Sometimes, these databases will include dimensional data in one table and metrics in another table. In order to bind this data into a single dataset, an analyst will need to use what is called a join, or a query that binds data between two or more tables. BigQuery supports most SQL join types, such as INNER_JOIN, LEFT_JOIN, OUTER_JOIN, and CROSS_JOIN. A join clause requires a type and a condition (with the exception of the CROSS_JOIN type).