Preparing Google Cloud
Since we will use Google BigQuery as our data warehouse, we will need a Google account to prepare BigQuery for loading the Stroopwafelshop data. For this, you will need the following:
- A new Google Cloud Trial account with $300 in free credits. Alternatively, you can reuse your existing Google Cloud account (in that case, any costs that are incurred, although likely minimal, are at your own risk)!
- A Google Cloud project named stroopwafelshop.
- A BigQuery dataset named stroopwafelshopdata.
- Three service accounts, assigned with IAM roles:
- A service account named
airbytethat’s been assigned the BigQuery Data Editor and BigQuery User roles. - A service account named
dbt-cloudthat’s also been assigned the BigQuery Data Editor and BigQuery User roles. - A service account for Tableau, including the BigQuery Data Viewer role for read-only access
- A service account named
- For each service account, you will need to create and download a key in JSON format. These will...
