BigQuery Surrogate Keys
Surrogate Keys are a common concept in traditional Data Warehouse, but are not common in BigData. Generating a sequential increasing number is difficult to parallelise, and alternatives, such as a HASH or CONCAT, can provide a similar unique identifier.