Google BigQuery
Updated
by
Mikkel Settnes
Using Google BigQuery opens up some additional services in connection with using Dreamdata.
Google Cloud Platform
To use Google BigQuery you first need an Google Cloud Platform account.
Dreamdata is an Google Cloud Partner, and if you have not already signed up to Google Cloud Platform you can do it here and get $500 of free credits.
Google BigQuery
With our BigQuery Integration you gain access to your Dreamdata data inside BigQuery, which will allow you run your own queries on our data models, as well as copy, manipulate, join and use the data within BigQuery or any other tool connected to your BigQuery.
With this integration we expose a Dataset of your Dreamdata Data within your BigQuery, but only to specific users.
If you are not familiar with Google BigQuery take a look at these how to guides.
Some key points:
- This data will be hosted in the region of your choosing
- Dreamdata will pay the data storage costs
- You will pay for querying costs
We will want to know the following:
- What Google Cloud Platform region/zone will you want the data to be? See all supported regions here.
- A list of emails of users that can make queries in the exported dataset. This could also be Google Cloud Service Account emails.
- A list of Google group email addresses that should be given query permission on the dataset
Note: Either (2) or (3) is required.
Don't forget to use your own billing project!
One of the most common problems when accessing your data in BigQuery is that you forget to always query the data using your own billing project. If you are having issues querying the data it is worth checking that first. If you unsure how to enable a billing project, the video above shows how to do this both for the BigQuery console and for Looker Studio.
