Try out all OWOX BI features with a trial period Start for free

How to get access to the Google BigQuery storage in Google Cloud Platform

You need access to Google BigQuery, a cloud data warehouse, to use most OWOX BI features. This storage is configured in the Google Cloud Platform project. It means you have to create a GCP project first. And if it has already been created, you need to add users and select an access level (permissions) in the settings.

In this article, we explain:

Read more about all OWOX BI features in the article "What is OWOX BI".

Create a Google Cloud Platform project

1. Go to cloud.google.com and click Try It Free. Enter your details and payment card info.

You can try some OWOX BI and Google BigQuery possibilities without providing a payment card info: Thanks to BigQuery Sandbox you can quickly try out OWOX BI with some limitations:
- 10 GB of active storage
- 1 TB of processed query
- Default partition expiration set to 60 days
- No streaming data support

However, if you add a payment card as a new user, Google provides you with $300 credit for one year for using the Cloud Platform services. And don’t worry — Google won’t withdraw any funds from your card without your confirmation. You will be charged $1 to check your card. This one dollar will be returned as soon as everything is OK.

2. As soon as your free trial is active, go to the Google Cloud Platform main page and click Select a projectGCP_create_project_1.png

3. In the pop-up window, click the + button to add a new project:GCP_create_project_2.png

4. On the project creation screen, choose the name and ID for your project, your billing account, organization and location that the project will be associated with. Then click Create:GCP_create_project_3.png

5. You’ll get a notification that the project has been created. The link in the notification leads to the project:

GCP_create_project_4.png

6. Done. Google BigQuery is enabled and working in your GCP project automatically. Now you can set up data collection to BigQuery in OWOX BI or upload to BigQuery CRM data, custom events data tables, or BigQuery Export data for GA 360, and use any of them as a data source for Attribution and Smart Data.

Provide access to your BigQuery data to the people who will work with it

Data sources in OWOX BI can only be managed by the users who:

  1. have access to the GCP project where the source data is being stored;
  2. have two roles: "BigQuery> BigQuery Data Editor" and "BigQuery User".

That's why you should provide the right access to the people who will work with your data in OWOX BI. If you manage all data in OWOX BI by yourself, skip this step and check that your user has the correct roles selected.

How to add a user and configure the necessary access

1. On the GCP left panel, find IAM & admin. In the drop-down menu, click IAM:
GCP_user_access_0.png

2. On the IAM (Identity and Access Management) screen, click Add:gbq-00-view-role-en.png

3. In the pop-up, enter the email of the person (one or more) who you want to grant access to. As a Role, select BigQuery > BigQuery Data Editor and BigQuery User:

Note: To make the further access to the data simpler for other OWOX BI users within your project, we recommend to use the BigQuery Admin role. Read about the accesses for each role in the Google BigQuery documentation.

gbq-03-add-user-role-en.png

Once you have granted the users with these roles, they can manage data from BigQuery in OWOX BI.

How to edit access for a previously added user

1. If in the list of users, you see that the user doesn't have enough access level to work with Google BigQuery data, click on the Edit icon in line with this user's name.

gbq-0.5-edit-permission-role-en.png

2. In the pop-up, add two roles for this user: BigQuery> BigQuery Data Editor and BigQuery User.

gbq-01-edit-permission-role-en.png

gbq-02-edit-permission-role-en.png

3. Then click the Save button. Now, in the list of users, the newly edited user will have new roles.

gbq-04-role-ok-en.png

 

Useful linkRead more about setting up a Google Cloud Platform project in Google documentation.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.