Buried in the BigQuery "Standard SQL" blog post is support for DELETE and UPDATE statements. This is HUGE for BigQuery - the biggest problem has always been tha

Buried in the BigQuery "Standard SQL" blog post is support for DELETE and UPDATE statements. This is HUGE for BigQuery - the biggest problem has always been that it's an append-only data warehouse. My company does ETL-as-a-service (https://fivetran.com/ https://fivetran.com/) and we've had beta support for BigQuery for the last few months using a somewhat crazy copy-the-table-every-time strategy. We're really excited to have DELETE and UPDATE and we'll be switching over in the next few days.