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 a Google Cloud Platform account.
Dreamdata is a Google Cloud and BigQuery Ready Partner. If you have not already signed up for Google Cloud Platform, you can do it here and get $300+$200 of free trial credits.
Google BigQuery
With our BigQuery Integration, you gain access to your Dreamdata data inside BigQuery. This will allow you to 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 can be hosted in either the EU or US region, sub-regions are not supported
- 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? Either EU or US.
- A list of users' emails 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.
