Canvas Docs
  • GETTING STARTED
    • Our docs have moved
    • Connect your data
      • App and database connectors
      • Snowflake
      • BigQuery
      • Redshift
      • Postgres
        • Use an SSH tunnel
      • Static IP Addresses
      • dbt
        • dbt Cloud
        • dbt via GitHub
    • Create your first canvas
    • Onboarding your team
  • Building canvases
    • Import data
    • Formulas
    • SQL
    • Joins
    • Pivot tables
    • Charts
    • Filters
      • Date filters
      • Text search filters
      • Multi-select filters
    • Canvas API
    • Events API
    • Embed Login API
  • Embeds
    • Public Embeds
    • Scopes
    • Walkthrough
    • PowerPoint embeds
  • Managing users
    • Assigning permissions
  • Security
    • Data security
    • Bug bounty program
    • Privacy policy
    • Terms of service
Powered by GitBook
On this page
  1. GETTING STARTED
  2. Connect your data

BigQuery

Connect your BigQuery warehouse to explore and visualize your data

PreviousSnowflakeNextRedshift

Last updated 2 years ago

Connecting to BigQuery requires creating a with sufficient permissions to run jobs and query data, creating a JSON private key for this user, then uploading the key to Canvas. You can read more about how we keep your data safe .

We recommend creating a separate service account with just the required roles following the principle of least privilege.

Login to your .

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

Click Create Service Account

Fill out the form and click Create

On the following page, grant at least the roles BigQuery Data Owner and BigQuery Job User

Click done, then select the service account that you just created

On the next page, select the Keys tab

Click Add Key > Create new key

Select JSON

Click Create - your JSON key should download automatically

Upload this key to Canvas on the page shown below

Service account
here
Google Cloud Console