Skip to main content
All CollectionsIntentwise Analytics CloudConfiguring Data Pipeline
How to provide access to new data copy software for BigQuery database
How to provide access to new data copy software for BigQuery database

Read the article and follow the step-by-step instructions for providing access to the new data copy software

Raghavendra Seshadri avatar
Written by Raghavendra Seshadri
Updated over a month ago

Create cloud storage bucket

To create the bucket in Google cloud storage follow these steps:

  1. Choose the project which was initially created for Intentwise

  2. Navigate to the Cloud Storage Buckets page.

  3. Click Create

  4. In the Get Started Page Enter globally unique name of your choice for the folder.

  5. Click Continue

  6. In the "Choose where to store your data" section, select the same location as the project, for example: us-west1.

  7. Click "Create" at the bottom of the page. You can skip the other options like "Choose Storage Class" and "Control Access."

Steps for creating service account

  1. Sign in to your Google console at https://console.cloud.google.com

  2. Choose the project which was initially created for Intentwise

  3. Open the Burger Menu on the side and Go to IAM -> Service Accounts.

  4. In the Service Accounts page, Click on the Create Service Account button on the top. You should now see a form to create a service account. Fill in any Service Account Name, Service Account ID, Service Account Description. Below is an example –

  5. Click "Create and Continue." You should now see an option to assign Service Account permissions. Under that, there will be a dropdown. Search for the roles listed below and add them. Use "Add Another Role" to include each of the following roles:

    1. BigQuery Data Editor

    2. BigQuery Job User

    3. Storage Object User

    4. BigQuery Read Session User

    5. Storage Admin:

      1. When adding Storage Admin Click on Add IAM Condition

      2. Enter any title

      3. In the Condition builder choose below options:

        1. Condition type - Name

        2. Operator - is

        3. Value - projects/_/buckets/bucket-name. Replace only the bucket-name with the bucket created in the previous step. Example: projects/_/buckets/bucket-name

  6. Once all the Roles are assigned click Done

  7. On the next screen, Click on the newly created Service account email. Choose the KEYS tab. Click on Add Key

  8. Choose Key type JSON and click Create.

  9. Now, login to the Intentwise platform and navigate to My Connections under Intentwise Analytics Cloud. Click on Bigquery under My data Destinations

  10. Add the Bucket Name and upload the Service account private key downloaded in step 8 and click on Save.

  11. For any further questions ,please reach out to us on chat or at [email protected].

Did this answer your question?