Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/bigquery/docs/table-snapshots-intro below:

Introduction to table snapshots | BigQuery

Stay organized with collections Save and categorize content based on your preferences.

This document is an introduction to BigQuery table snapshots. It is the first of a set of documents that describes how to work with BigQuery table snapshots, including how to create, restore, update, get information about, and query table snapshots. This document set is intended for users who are familiar with BigQuery and BigQuery tables.

A BigQuery table snapshot preserves the contents of a table (called the base table) at a particular time. You can save a snapshot of a current table, or create a snapshot of a table as it was at any time in the past seven days. A table snapshot can have an expiration; when the configured amount of time has passed since the table snapshot was created, BigQuery deletes the table snapshot. You can query a table snapshot as you would a standard table. Table snapshots are read-only, but you can create (restore) a standard table from a table snapshot, and then you can modify the restored table.

Benefits of using table snapshots include the following:

• Keep a record for longer than seven days. With BigQuery time travel, you can only access a table's data from seven days ago or more recently. With table snapshots, you can preserve a table's data from a specified point in time for as long as you want.

• Minimize storage cost. BigQuery only stores bytes that are different between a snapshot and its base table, so a table snapshot typically uses less storage than a full copy of the table.

If you need mutable, lightweight copies of your tables, consider using table clones.

Access control for table snapshots is similar to access control for tables. For more information, see Control access to resources with IAM.

You query a table snapshot's data in the same way as you query other types of BigQuery tables. For more information, see Querying BigQuery data.

Storage costs apply for table snapshots, but BigQuery only charges for the data in a table snapshot that is not already charged to another table:

• When a table snapshot is created, there is initially no storage cost for the table snapshot.

• If new data is added to the base table after the table snapshot was created, then you don't pay for storage of that data in the table snapshot.

• If data is changed or deleted in the base table that also exists in a table snapshot, the following charges occur:

  • You are charged for the table snapshot storage of the changed or deleted data.

  • If the base table is billed as physical storage, time travel and failsafe charges aren't charged to the base table. When the snapshot is deleted, you are charged for time travel and failsafe.

  • If there are multiple snapshots that contain the changed or deleted data, you are only charged for the storage used by the oldest snapshot.

• When you copy a table snapshot or clone within a same region or from one region or multi-region to another, a full copy of the table is created. This incurs additional storage costs.

The difference between base table and table snapshot storage charges is shown in the following image:

For more information, see BigQuery storage pricing.

• A table snapshot must be in the same region, and under the same organization, as its base table. If you select a dataset in a different region, BigQuery creates a copy of the table in the target dataset in that region.

• Table snapshots are read-only; you can't update the data in a table snapshot unless you create a standard table from the snapshot and then update the data. You can only update a table snapshot's metadata; for example, its description, expiration date, and access policy.

• You can only take a snapshot of a table's data as it was seven days ago or more recently, due to the seven-day limit for time travel.

• You can't take a snapshot of a view or a materialized view.

• You can't take a snapshot of an external table.

• You can't overwrite an existing table or table snapshot when you create a table snapshot.

• If you snapshot a table that has data in write-optimized storage (streaming buffer), the data in the write-optimized storage is not included in the table snapshot.

• If you snapshot a table that has data in time travel, the data in time travel is not included in the table snapshot.

• If you snapshot a partitioned table that has a partition expiration set, the partition expiration information isn't retained in the snapshot. The snapshotted table uses the destination dataset's default partition expiration instead. To retain the partition expiration information, copy the table instead.

For information about the quotas and limits that apply for table snapshots, see Table snapshots quotas and limits.

• Create a table snapshot.
• Restore a table snapshot.
• Update a table snapshot's description, expiration date, or access policy.
• Create monthly snapshots of a table by using a service account that runs a scheduled query.
• Automate snapshots at the dataset level.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["BigQuery table snapshots preserve the contents of a base table at a specific point in time, allowing users to retain data beyond the seven-day limit of time travel."],["Table snapshots are read-only and incur storage costs only for data that differs from the base table, optimizing storage efficiency compared to full table copies."],["You can query snapshots like standard tables, restore them to create modifiable tables, and manage their metadata such as descriptions and expiration dates."],["Table snapshots are subject to certain limitations, such as being restricted to the same region and organization as their base table, and not including data from write-optimized storage or time travel."],["BigQuery provides a variety of actions for table snapshots such as creating, restoring, updating, and automating snapshots at the table level or the dataset level, allowing for better data management."]]],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4