Just to bring the BQ capabilities up-to-date a bit:

• Transaction Support: https://cloud.google.com/bigquery/docs/reference/standard-sql/transactions

• Roles & Access: Pretty robust now, support SQL as well, e.g:

```

GRANT `roles/bigquery.dataViewer`

ON SCHEMA DATASET

TO "group:my-group@example.com"

```

see https://cloud.google.com/bigquery/docs/reference/standard-sql/data-control-language#grant_statement