BigQuery atomic load on time partitioned tables?

0
votes

Follow up on 2012's atomic inserts in big query.

Are BigQuery load jobs to a new partition on an existing Ingestion-time partitioned table atomic?

Would the new _PARTITIONTIME and its records only be available and present once all records are loaded?

1
google-bigquery

1 Answers

1
votes

Yes, all load/query//copy jobs in BigQuery are atomic. The only exception is script jobs, where each query in the script is atomic.