Ingenious DWH is built using Google BigQuery, you need a Google Project and a Google Account (or Service Account) to access it. Also you Google Account’s email will be used to restrict the data according to the Roles&Rights of the Ingenious User Account. Go through the following steps to get proper access to Ingenious DWH.

Ingenious user account

• You need an Ingenious user account

• The email of the user account has to be the primary email address of a valid Google Account (see “Google Account” section). If you access BigQuery using a service-account, the please create a user using the service-account email (i.e. account-1@myproject-001.mycompany.com.iam.gserviceaccount.com).

• You must have permissions to see resources (entities, advertisers, partners)

  

   

• The Ingenious user requires the following permissions: 

  • you must have the right to open Reporting

    

     

Google Account

• BigQuery requires a Google Account (or a Service Account) with the same email address as the Ingenious user account mentioned in “Ingenious user account”

• This Google Account must be enabled by Ingenious Support for the use of data. If this is not yet the case, please contact our Service Team

Google Cloud Project

When you run a BigQuery SQL Query or access to the data with other tools like DataStudio, Google will charge small fee for the amount of data processed during the request (see https://cloud.google.com/bigquery/pricing#on_demand_pricing ). That’s why you need to specify a billing project for access to BigQuery data.

• If you still don’t have a Google Cloud Project, you or your company’s admin) can create it.

• If you use BigQuery intensively, you will go beyond the free contingent of 1TB per Month, so you have to create a billing account for your project.

Permission to run BigQuery jobs

After you created the Cloud Project with billing, you need also the permission to use it project for BigQuery Jobs. The according permission is bigquery.jobs.create and is a part of the Role BigQuery.JobUser which your account need to be assigned to on project level. The best practice is to create a Google Group, give them the permission to run jobs, and then assign people to the group like shown below:

Next steps

• After your account has met all of the above requirements, you can now test the access using BigQuery console like described in https://ingenioustechnologies.atlassian.net/l/c/Ptz1wj3d

• If you use a service-account, follow the introduction for BigQuery authentication.