Also read - Backup and Restore for Cloud SQL

Cloud Storage - Getting Data In

  • For simply inbound transfers, use the Transfer Service.
  • It can run on a schedule.
  • It is free

Cloud Storage Restores

Require a lifecycle policy.

Read Automating Lifecyle policies on cloud storage in GCP

Loading Data from Cloud Storage (into bigquery)

When you load newline delimited JSON data from Cloud Storage, you can load the data into a new table or partition, or you can append to or overwrite an existing table or partition. When your data is loaded into BigQuery, it is converted into columnar format for Capacitor (BigQuery's storage format).

  • bigquery.tables.create
  • bigquery.tables.updateData
  • bigquery.jobs.create




Need an experienced Cloud Networking or a Cloud Data Protection Expert?  Anuj has successfully delivered over a dozen deployments on each of the public clouds (AWS/GCP/Azure) including several DevSecOps engagements. Set up a time with Anuj Varma.