Behind the Cloud - Setting up a Dataform project within BigQuery

☁️ In this episode of Behind the Cloud, Matt demonstrates how to enable and set up a Dataform project within BigQuery, connect it to GitHub, and initialise the workspace for building a Dataform project. Matt walks us through enabling BigQuery, creating a repository, setting up the region, and using service accounts. ☁️ Book your dataform consultation with Measurelab - https://solutions.measurelab.co.uk/da... Timestamps 00:00:00 - Introduction to Dataform in BigQuery 00:00:36 - Enabling BigQuery and Accessing Dataform 00:00:46 - Creating a New Repository in Dataform 00:01:07 - Setting Up a Service Account 00:01:27 - Exploring Repository Settings 00:01:49 - Connecting Dataform to GitHub via HTTPS 00:02:31 - Generating a GitHub Token 00:03:33 - Using Google Secret Manager 00:04:47 - Adjusting IAM Permissions for Dataform 00:05:07 - Successfully Linking GitHub to Dataform 00:05:28 - Creating a Development Workspace 00:06:09 - Initialising the Workspace 00:06:32 - Committing and Pushing to GitHub ---- In this series, Matt aims to address pertinent questions about GCP, covering topics from security concerns to the costs of using BigQuery and other services. The series will feature bite-sized videos targeted at analysts and digital marketers who are contemplating the transition to cloud-based technologies. More from Measurelab 👉 https://rb.gy/mjnpla 🚀 Connect with us: Subscribe now to stay updated on the latest episodes and be part of our growing community. Have specific questions? Drop them in the comments below!