GCP Big Query table snapshots creation automation | Schedule script using service account

For scheduling SQLs using GCP console , watch below video
   • Big Query Editor Schedule  SQL/Script