Home » Bigquery » Tutorials » Copy to Snapshot table

BigQuery Copying Snapshot table to another Snapshot table

Snapshot table stores the snapshot of a table. It provides cost savings as you only pay for modified partitions only in the base table. You can also copy from a snapshot table to another snapshot table

Copy to Snapshot table example

    CREATE SNAPSHOT TABLE myproject.library_snapshot_backup.books
      CLONE myproject.library_backup.books