Google BigQuery

Mikkel Settnes 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.

Dreamdata Google Cloud Partner

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:

  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.

How did we do?

Connect to AWS Redshift using AWS Glue