Export all tables data under dataset to GCS

[mounika2]

Dear Team,

Greeting of the day...!

Requirement:

Export all tables under dataset to Google Cloud Storage with automation. That stored data should be restored back to dataset.

I can be able to export the single table in csv format to GCS.

But I need to store all tables data under dataset with CSV format in GCS and able to restore that data to dataset whenever we want.

Please assist me in this.

Thanks in advance.

[KirTitievsky]

To clarify: you want to back up BigQuery tables to GCS.  Is this to be done once? Or do you need to actively maintain backups for all tables regularly?