
3/25/2025 · Regnard Raquedan
What this post added
This post details a tutorial for securely publishing BigQuery data using GitLab CI/CD. It outlines the architecture involving version-controlled SQL, automated authentication with Google Cloud (service accounts or Workload Identity Federation), BigQuery query execution, export to CSV, and upload to Google Cloud Storage with public read ACLs. It also provides specific steps for configuring GitLab CI/CD variables and the `.gitlab-ci.yml` file.