Connect to BigQuery

‍Connect to BigQuery

  1. Open your Admin Portal by selecting ‘Administration’ in the user menu at the top right of your screen.
    Screen_Shot_2020-05-13_at_1.42.36_PM.png
  2. Select the ‘Connections’ page from the left hand panel.

    Screen_Shot_2020-05-13_at_3.54.08_PM.png

  3. Click the ‘Create Connection’ button.
  4. Name your connection.
  5. Select ‘BigQuery’ under warehouse type.
  6. You will then be prompted to specify your 'Connection Credentials'.

    Screen_Shot_2020-05-18_at_2.01.54_PM.png

  7. Under ‘Billing project ID’, enter your ‘Project ID’. This can be found on your GCP console under ‘Project Info’.
  8. Under ‘Service account’, paste the json key you created when setting up your service account. 
  9. [optional] Under 'Connection Features’, you can set a connection timeout and/or enable write access.
  10. After completing the form, click the ‘Create’ button near the top right of your screen.

Your BigQuery Service Account

In Google Cloud Platform (GCP), create a service account for your BigQuery instance. To connect to Sigma, you will need to complete the following steps:

  • Add the following roles to your service account:
    • "BigQuery Data Viewer"
    • "BigQuery Job User"
  • Create the json key you will use to connect to Sigma. A file will be downloaded to your computer.