Tutorial: Secure BigQuery data publishing with GitLab
Mar 25, 2025Regnard Raquedan

Summary
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.