1. Home »
  2. Analytics AI »
  3. User guide »
  4. Connections »
  5. Google Cloud »
  6. Bigquery

BigQuery

Transfer your data from Google cloud BigQuery to bizstats AI analytical platform and start doing the search based analytics. 

Steps to create BigQuery connection 

Step 1: Select BigQuery data source

  1. Go to Project details page
  2. From the subsection "Connection"
  3. Click add 
  4. You will be landed in the select source page ( selected Filter category : All )
  5. Change the filter category to Google cloud
  6. Select BigQuery source from the list 

Step 2:  Give your credential details

Pop-up appears with Create new connection form

  1. Connection name
    1. Fill the connection name 
      1. This field is for your future reference so give any meaningful name.
  2. Credentials details
    1. Fill the following details
      1. ProjectId
        Google cloud project id, in which the source data present (Refer How to identify google cloud  project id?)
      2. Grant Permission
        Add "BigQuery Data Viewer" & "BigQuery Job User"role to the following email
        "444929934777-compute@developer.gserviceaccount.com"
  3. Test connection
    1. After giving your credential information click test connection button
      1. This will verify your connection and show the success message
        1. In case of any issues test connection fails. 
          Please verify your project id and permission details 
  4. Save connection
    1. On success of test connection, save the connection
logo