Configuring Data Pipeline
      Back to home
      1. Knowledge Base
      2. Intentwise Analytics Cloud
      3. Configuring Data Pipeline

      How to Provide Access to Existing BigQuery for Data Import

      Read the article and follow the step-by-step instructions for providing access to your BigQuery database for data import.


      Create a cloud storage bucket

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

      1. Choose the project for which you would like to provide access.

      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. Below is an example bucket name.

         

      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 a service account

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

      2. Choose the project for which you would like to provide access.

      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 any generic name which does not include Intentwise, 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 help@intentwise.com.