CODEWITHSUNDEEP
google-bigquery
Uli Bethke
Uli Bethke

Reputation: 810

BigQuery copy command

I have been going through the book Google BigQuery Analytics. On page 354 it states that a table copy completes in less than a minute irrespective of table size. Is this correct? How is it possible?

Upvotes: 0

Views: 69

Answers (1)

Felipe Hoffa
Felipe Hoffa

Reputation: 59325

Let's test that assessment.

I have a 2TB table with 55 billion rows:

enter image description here

I will ask BigQuery to make a copy of it:

enter image description here

The requested job was completed in 55 seconds - less than a minute:

enter image description here

So let me answer the 2 questions above:

  • On page 354 it states that a table copy completes in less than a minute irrespective of table size. Is this correct?

The book is old, but the answer is still "yes".

  • How is it possible?

BigQuery is powered by

unicorns and rainbows

Upvotes: 1

Related Questions