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.

Dreamdata Google Cloud Partner

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 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:

  1. What Google Cloud Platform region/zone will you want the data to be? See all supported regions here.
  2. A list of emails of users that can make queries in the exported dataset. This could also be Google Cloud Service Account emails.
  3. 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.

How did we do?