From the course: Advanced BigQuery

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Snapshots

Snapshots - BigQuery Tutorial

From the course: Advanced BigQuery

Start my 1-month free trial Buy for my team

Snapshots

“

- [Instructor] In this demo, we will take a quick look at how we can create snapshots of tables. These snapshots could be used in order to recover from failures, in order to restore the contents of a table, or even to share with other users before the table goes through some changes. The specific table we will be working with in this demo is supermarket_sales, once again. In order to create a snapshot, we first open it up. From these details, you'll note that there is an option to copy your table which will create a copy based on its current contents. We will soon see that snapshots are a little more sophisticated than a regular copy. First though, let's quickly head over to details and confirm that the number of rows in this table is 1000, which gives us an idea of the size of the snapshot. And now to create one, we just expand the additional menu options and click on snapshot. Now I did mention that a snapshot is a…

Contents