BigQuery Atomic Operations

We start by explaining a common mistake made on designing systems using BigQuery without using atomic operations, followed by how to design a better system by using two mostly used BigQuery atomic operations.

Useful to read
- ACID: https://en.wikipedia.org/wiki/ACID
- Write Disposition: https://googleapis.dev/python/bigquery/latest/generated/google.cloud.bigquery.job.WriteDisposition.html
- MERGE: https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#merge_statement

Видео BigQuery Atomic Operations канала PracticalGCP