How to Enable Data via BigQuery to INCRMNTAL

This article explains how to enable and onboard raw or aggregated data from Google Cloud BigQuery to INCRMNTAL

Integration with BigQuery requires three steps:
  • Create a Service Account for INCRMNTAL
  • Enable BigQuery API 
  • Choose BigQuery Table

Create a Service Account

  1. Sign in to Google Cloud Platform Console
  2. Navigate to IAM & Admin > Service Account
    image11
  3. Click “ + Create Service Account”
    image8
  4. Name the new service account INCRMNTAL and click “Create
    image2-1

    This will be used in a later stage to grant permission for the relevant data set.

  5. In the 2nd step, set the permission to the service account to “BigQuery Job User” and click “Continue” to finish the Service Account creation process
    image9
  6.  Click the   ➕   symbol at the raw and click “Create Key
    image4
  7. Choose the JSON format and click “Create
    image7
  8. Send the file created to onboarding@incrmntal.com 
 

Enable BigQuery API

By default, BigQuery API is enabled. But in case you run into difficulties, you may need to enable this feature.

  1. Navigate to APIs & Services on the Google Cloud Console menu
  2. Click “+ Enable APIs and Services
    image5
  3. Search for “BigQuery API” > Select and click “Enable
    image6

     

Choose BigQuery Table

  1. Navigate to BigQuery product page, and choose the relevant table you would like to share with INCRMNTAL

Note: This step should be repeated for each table you would like to provide access to INCRMNTAL

   2.  Select the option to “Share Table

image10


   3.  Enable the INCRMNTAL Member you created in the earlier step (Create Service Account). Set the role as “BigQuery Data Viewer”. Click “Add

image3

   4.  Click “Done” 

 

For any question please contact onboarding@incrmntal.com , or open a support Ticket here