Grant bigquery.dataViewer on individual datasets rather than at the project level to limit Summation’s read scope to exactly what you intend.
Form fields
Field
Required
Stored as
Notes
Project ID
Yes
Config
The GCP project Summation runs jobs in, e.g. my-gcp-project-123. See Identifying projects.
Dataset ID
Optional
Config
Default dataset for attached tables whose source reference does not name one. It does not restrict browsing; you can browse and attach tables from any dataset the service account can read, whatever this is set to. See Datasets overview.
Location
Optional
Config
BigQuery region, e.g. US, EU, us-east4. Collected by the form but not currently applied when browsing or reading, so setting it does not change which datasets are reachable. See Dataset locations.
Service Account JSON
Yes
Secret
The full contents of the JSON key file (including the surrounding { and }).
Enter a name (for example summation) and click Create and Continue.
On Grant this service account access, add these three roles, then click Continue and Done:
Role
Purpose
BigQuery Job User (roles/bigquery.jobUser)
Run queries in the project
BigQuery Data Viewer (roles/bigquery.dataViewer)
Read tables and datasets
BigQuery Read Session User (roles/bigquery.readSessionUser)
Required for Arrow / Storage API reads
If you prefer to scope Data Viewer to individual datasets, skip it here and grant it per dataset after the account exists.
Open the new service account → Keys → Add Key → Create new key → JSON. The downloaded .json file is the credential for the form.
With gcloud
PROJECT_ID=my-gcp-project-123gcloud iam service-accounts create summation \ --project="$PROJECT_ID" \ --display-name="Summation"# Lets Summation run queries in the projectgcloud projects add-iam-policy-binding "$PROJECT_ID" \ --member="serviceAccount:summation@$PROJECT_ID.iam.gserviceaccount.com" \ --role="roles/bigquery.jobUser"# Required: Summation reads via Arrow / Storage API read sessionsgcloud projects add-iam-policy-binding "$PROJECT_ID" \ --member="serviceAccount:summation@$PROJECT_ID.iam.gserviceaccount.com" \ --role="roles/bigquery.readSessionUser"# Repeat per dataset you want to exposebq add-iam-policy-binding \ --member="serviceAccount:summation@$PROJECT_ID.iam.gserviceaccount.com" \ --role="roles/bigquery.dataViewer" \ "$PROJECT_ID:analytics"# Generate a JSON key, paste it into the form, then delete the local copygcloud iam service-accounts keys create summation-key.json \ --iam-account="summation@$PROJECT_ID.iam.gserviceaccount.com"
After saving the connection, browse the project’s BigQuery datasets and select tables or views. Source references use the form:
adbc:dataset_id.table_name
Common problems
Error or symptom
Likely cause
Access Denied: Project ... User does not have bigquery.jobs.create permission
Grant roles/bigquery.jobUser on the project.
Access Denied on bigquery.readsessions.create, Arrow, or Storage API
Grant roles/bigquery.readSessionUser on the project. Job User and Data Viewer are not sufficient.
Not found: Dataset ...
The service account can’t see the dataset (grant roles/bigquery.dataViewer on it), or the dataset name is wrong. Setting Location does not resolve this; it isn’t applied when browsing or reading.
Invalid JSON
Paste the full file contents including the surrounding { and }. Don’t escape or wrap the JSON.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Summation","colors":{"primary":"#000000","light":"#888888","dark":"#000000"},"logo":{"light":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685","dark":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685"},"favicon":{"light":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368","dark":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368"},"appearance":{"default":"light"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://app.summation.com/signup"}},"fonts":{"family":"Inter"},"contextual":{"options":["copy","view","claude","chatgpt"],"display":"header"},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"summation-676748f5","hasAudioNarration":false,"actualSubdomain":"summation-676748f5","customDomains":["docs.summation.com"],"gitSource":{"type":"github","owner":"summationai","repo":"code","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af5cda8b51d0e31167b5abb","clientVersion":"0.0.4205","searchFilterCounts":[{"language":"default","tag":"API","count":156},{"language":"default","tag":"Endpoints","count":144},{"language":"default","tag":"Documentation","count":49},{"language":"default","tag":"Tables","count":31},{"language":"default","tag":"Connectors","count":21},{"language":"default","tag":"Key concepts","count":20},{"language":"default","tag":"Data Connectors","count":17},{"language":"default","tag":"Grid","count":13},{"language":"default","tag":"Conversations","count":12},{"language":"default","tag":"Use cases","count":11}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"a[href=\"https://app.summation.com/signup\"]{border:0!important;box-shadow:none!important}a[href=\"https://app.summation.com/signup\"]>*{background:#000000!important;color:#ffffff!important;box-shadow:none!important;padding-right:1rem!important;padding-left:1rem!important;gap:0!important}a[href=\"https://app.summation.com/signup\"] span,a[href=\"https://app.summation.com/signup\"] svg{color:#ffffff!important}a[href=\"https://app.summation.com/signup\"] svg{display:none!important}a[href=\"https://app.summation.com/signup\"]:hover>*{background:#27272a!important}html[data-current-path=\"/home\"] .eyebrow{display:none}html[data-current-path^=\"/features/\"] .eyebrow{display:none}html[data-current-path=\"/home\"] #header{max-width:41rem;margin-top:3rem}html[data-current-path=\"/home\"] .mdx-content{margin-top:1.5rem}html[data-current-path=\"/home\"] #content-area{width:100%;max-width:64rem}html[data-current-path=\"/home\"] #header>p{margin-top:0.75rem;color:#52525b;font-size:1.125rem;line-height:1.75rem}.home-get-started{display:inline-flex;min-width:10rem;height:2.75rem;align-items:center;justify-content:center;gap:0.5rem;padding-inline:1rem;border-radius:0.75rem;background:#000000;box-shadow:none!important;color:#ffffff!important;font-size:0.875rem;font-weight:500;line-height:1;text-decoration:none!important;transition:background-color 120ms ease}.home-get-started:hover{background:#27272a;box-shadow:none!important}.home-get-started:focus-visible{outline:2px solid #000000;outline-offset:3px}.home-get-started img{width:1rem;height:1rem}.home-section-divider{width:100%;height:0.5px;margin-block:2.5rem;background:#e7e7e7}.home-section-divider+.card-group{margin-top:0!important}html[data-current-path=\"/home\"] .card-group{width:100%;max-width:64rem;grid-template-columns:repeat(3, minmax(0, 1fr))!important;justify-content:center;gap:1.5rem!important}html[data-current-path=\"/home\"] .card-group>.card{--primary: 228 228 231;display:flex;width:100%;min-height:9.5rem;padding:1.3125rem 1.5rem;align-items:center;box-sizing:border-box;margin-block:0!important;border:var(--border-width-border-half, 0.5px) solid\n var(--border-layout-divider, #e7e7e7)!important;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:var(--color-neutral-white, #ffffff);box-shadow:0 1px 2px 0 rgb(0 0 0 / 5%);transition:background-color 120ms ease,\n box-shadow 120ms ease}html[data-current-path=\"/home\"] .card-group>.card:hover{background:#f4f4f5;border-color:#e4e4e7!important}html[data-current-path=\"/home\"] .card-group>.card>div{height:100%;width:100%;padding:0}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-title\"]{font-size:0.9375rem!important}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-content\"]{color:var(--home-card-description, #52525b)!important;font-size:0.875rem!important;line-height:1.25rem!important}html[data-current-path=\"/home\"] .card-group>.card svg{color:#000000!important}html.dark[data-current-path=\"/home\"] .card-group>.card{--primary-light: 63 63 70;--home-card-description: #888888;border-color:#3f3f46!important;background:#18181b}html.dark[data-current-path=\"/home\"] .card-group>.card svg{color:#f4f4f5!important}html.dark[data-current-path=\"/home\"] .card-group>.card:hover{background:#27272a;border-color:#3f3f46!important}html.dark[data-current-path=\"/home\"] .home-section-divider{background:#27272a}.card{background-color:#fafafa!important;transition:background-color 120ms ease,\n border-color 120ms ease}.card:hover{background-color:#f4f4f5!important}html.dark .card{background-color:#18181b!important}html.dark .card:hover{background-color:#232326!important}#content-area{box-sizing:content-box;width:auto;max-width:700px;margin-inline:auto}#page-title{font-size:2rem!important;line-height:2.5rem!important}#page-context-menu-button{border-radius:8px 0 0 8px!important}#page-context-menu>button[aria-label=\"More actions\"]{border-radius:0 8px 8px 0!important}html[data-current-path=\"/home\"] #page-context-menu{display:none!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:first-child{border-color:transparent!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:nth-child(2)>div:first-child>svg{display:none!important}.mdx-content{font-size:15px;letter-spacing:-0.1px}.mdx-content a.link{border-bottom:0;font-weight:400;text-decoration-line:underline;text-decoration-style:dotted;text-decoration-color:#a1a1aa;text-decoration-thickness:from-font;text-decoration-skip-ink:none;text-underline-position:from-font;transition:text-decoration-color 120ms ease-out}.mdx-content a.link:hover{text-decoration-style:solid;text-decoration-color:currentColor}@media (prefers-reduced-motion: reduce){.mdx-content a.link{transition:none}}.mdx-content>h2{margin-top:3rem!important}#table-of-contents-content{--toc-indicator-height: 1.5rem;--toc-indicator-y: 0px;position:relative;border-left:1px solid #e4e4e7}nav:has(>div>#table-of-contents-content)>h2{display:none}#table-of-contents-content::before{position:absolute;top:0;left:-2px;width:3px;height:var(--toc-indicator-height);border-radius:0;background:#27272a;content:\"\";opacity:0;pointer-events:none;transform:translateY(var(--toc-indicator-y));transition:transform 240ms cubic-bezier(0.4, 0, 0.2, 1),\n height 240ms cubic-bezier(0.4, 0, 0.2, 1),\n opacity 120ms ease-out}#table-of-contents-content[data-has-active=\"true\"]::before{opacity:1}@media (prefers-reduced-motion: reduce){#table-of-contents-content::before{transition:opacity 120ms ease-out}}#table-of-contents-content .toc-item>a{padding-left:calc(\n var(--toc-padding-left) + var(--toc-focus-padding, 0rem) + 1rem\n )!important}#table-of-contents-content .toc-item[data-active=\"true\"]>a{font-weight:400;text-shadow:none!important}#table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#4f4f4f}#table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#000000}.dark #table-of-contents-content{border-left-color:#3f3f46}.dark #table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#9e9e9e}.dark #table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#888888}.dark #table-of-contents-content::before{background:#f4f4f5}#navigation-items .sidebar-group>li+li{margin-top:4px}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{width:calc(100% - 0.5rem)!important;margin-left:0.5rem}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{padding-top:0.25rem!important;padding-bottom:0.25rem!important;line-height:1.25rem!important}#sidebar a[aria-current=\"page\"]{background-color:#f4f4f5!important;border-radius:8px!important;color:#000000!important;font-weight:500!important;text-shadow:none!important}#navigation-items a:not([aria-current=\"page\"]):hover{background-color:#fafafa!important}.dark #navigation-items a:not([aria-current=\"page\"]):hover{background-color:#18181b!important}.dark #sidebar a[aria-current=\"page\"]{background-color:#27272a!important;color:#ffffff!important}#sidebar button[aria-expanded]>div:last-child{margin-left:auto}#navigation-items .sidebar-group a span,#navigation-items .sidebar-group button span{hyphens:none}div:has(>form #search-input){padding:0!important;border:0!important;background:transparent!important;box-shadow:none!important}#theme-preference-menu-trigger{width:2.25rem;height:2.25rem;padding:0!important;border:0.5px solid #e4e4e7;border-radius:0.625rem!important}#theme-preference-menu-trigger [data-theme-preference-icon]{display:none!important}#theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:inline-flex!important}html[data-summation-theme-toggle=\"ready\"] #theme-preference-menu-content{display:none!important}.dark #theme-preference-menu-trigger{border-color:#27272a}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:none!important}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"light\"]{display:inline-flex!important}#header-ask-ai,#assistant-entry{display:none!important}.chat-assistant-floating-input{display:none!important}#pagination{display:grid;grid-template-columns:repeat(2, minmax(0, 1fr));gap:1.5rem;padding:0}#footer{border-top:0!important}html[data-current-path=\"/home\"] #pagination{display:none!important}#pagination>a{display:grid;box-sizing:border-box;min-width:0;height:5rem;align-content:center;padding:1rem 1.5rem;column-gap:0.75rem;row-gap:0.5rem;border:1px solid #e4e4e7;border-radius:0.75rem;background:transparent;font-weight:400;transition:border-color 120ms ease,\n background-color 120ms ease}#pagination>a:hover{border-color:#d4d4d8;background:#fafafa}#pagination>a::before{color:#71717a;font-size:0.8125rem;font-weight:400;line-height:1.25rem}#pagination .pagination-prev{grid-template-columns:auto minmax(0, 1fr)}#pagination .pagination-prev::before{grid-column:2;grid-row:1;content:\"Previous\"}#pagination .pagination-next{grid-template-columns:minmax(0, 1fr) auto;margin-left:0;text-align:right}#pagination .pagination-next::before{grid-column:1;grid-row:1;content:\"Next\"}#pagination [data-component-part=\"pagination-chevron\"]{grid-row:1;width:0.25rem;height:0.5rem;align-self:center;stroke-width:1}#pagination [data-component-part=\"pagination-chevron\"] path{stroke-width:1!important}#pagination [data-component-part=\"pagination-title\"]{grid-column:1 / -1;grid-row:2;color:#27272a;font-size:0.9375rem;font-weight:400;line-height:1.5rem}.dark #pagination>a{border-color:#3f3f46}.dark #pagination>a:hover{border-color:#52525b;background:#18181b}.dark #pagination [data-component-part=\"pagination-title\"]{color:#f4f4f5}header .max-w-8xl{max-width:none!important;margin-inline:0!important}#navbar a[href=\"/\"]:has(.nav-logo){display:flex;align-items:center}#navbar a[href=\"/\"] .nav-logo{height:1.25rem!important}.dark #navbar a[href=\"/\"] .nav-logo{filter:invert(1)}#navbar .max-w-8xl>div>div>.flex.items-center{padding-inline:1.5rem!important}@media (max-width: 639px){#navbar a[href=\"/\"] .nav-logo{height:1.125rem!important}}#navbar>div:first-child{border-bottom-color:#f0f0f0!important}:root{--topbar-tabs-height: 0rem !important}@media (min-width: 1024px){#navbar div.hidden.lg\\:flex.px-12.h-12{position:absolute!important;top:0!important;left:183px!important;height:4rem!important;padding:0!important;width:auto!important}#navbar .nav-tabs{column-gap:2rem}#navbar .nav-tabs-item{gap:0.5rem;white-space:nowrap}#navbar .nav-tabs-item:hover>div.absolute.bottom-0{background-color:currentColor}#navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#27272a!important}.dark #navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#888888!important}#navbar .nav-tabs-item[aria-current=\"location\"]{text-shadow:none!important}}@media (min-width: 1024px){#navbar div:has(>#search-bar-entry){flex:0 1 16rem;min-width:12rem}#navbar div:has(>nav[aria-label=\"Main\"]){flex:0 0 auto;margin-left:0}}#search-bar-entry:focus-visible{outline:2px solid currentColor;outline-offset:2px}.sidebar-group-header--collapsible{cursor:pointer;user-select:none}.sidebar-group-header--collapsible:hover{color:#18181b}.dark .sidebar-group-header--collapsible:hover{color:#f4f4f5}.sidebar-group-header--collapsible:focus-visible{outline:2px solid #a1a1aa;outline-offset:2px;border-radius:4px}.sidebar-group-chevron{margin-left:auto;transform:rotate(90deg);transition:transform 120ms ease}.sidebar-group-header--collapsible[data-sidebar-collapsed=\"true\"] .sidebar-group-chevron{transform:rotate(0deg)}ul.sidebar-group[data-sidebar-collapsed=\"true\"]{display:none}header div:has(>#theme-preference-menu-trigger){margin-left:0.5rem!important}#navbar nav:has(a[href=\"https://app.summation.com/signup\"]){margin-right:0!important}header a[href=\"https://app.summation.com/signup\"]{padding-inline:0.75rem!important}header a[href=\"https://app.summation.com/signup\"]>div{padding-inline:0!important;background:#000000!important}@media (min-width: 1024px){html[data-current-path=\"/home\"] #content-container{position:relative;left:7.5rem}#sidebar{width:280px!important;max-width:280px;transform:translateX(min(-2rem, calc((92rem - 100vw) / 2 - 2rem)));border-right:1px solid #f0f0f0}html:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #sidebar{transform:translateX(min(-2rem, calc((115rem - 100vw) / 2 - 2rem)))}#sidebar>#sidebar-content{top:0!important;left:1.5rem!important}#sidebar-content>[class~=\"pr-8\"]{padding-right:1.5rem!important}#sidebar-content .sticky.top-0.h-8{height:1.5rem}#sidebar-content>[data-component-part=\"scroll-area-scrollbar\"][data-orientation=\"vertical\"]{inset-inline-end:-2.5px!important;margin-inline:0!important}.dark #sidebar{border-right-color:rgba(255, 255, 255, 0.18)}}@media (min-width: 1280px){html[data-current-path=\"/home\"] #header,html[data-current-path=\"/home\"] .mdx-content{transform:translateX(-1.625rem)}html[data-current-path=\"/home\"] .mdx-content{width:calc(100% + 5.25rem)}}@media (min-width: 1024px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:0}}@media (min-width: 1280px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #header,html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{transform:none}html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{width:100%}}@media (min-width: 1600px) and (max-width: 1839px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:calc(50vw - 50rem)}}@media (max-width: 767px){#pagination{grid-template-columns:minmax(0, 1fr)}html[data-current-path=\"/home\"] #header{margin-top:2rem}html[data-current-path=\"/home\"] #header>p{font-size:1rem;line-height:1.5rem}.home-section-divider{margin-block:1.5rem}html[data-current-path=\"/home\"] .card-group{grid-template-columns:minmax(0, 1fr)!important}}figure[data-name=\"frame\"]{padding:1.25rem!important;margin-top:0!important;margin-bottom:1.5rem!important;border-radius:var(--border-radius-rounded-xl, 0.75rem)!important;background:#fafafa!important}.columns figure[data-name=\"frame\"]{margin-bottom:0!important}.columns{margin-top:0!important;margin-bottom:1.5rem!important;row-gap:1.5rem!important}html.dark figure[data-name=\"frame\"]{background:#18181b!important}figure[data-name=\"frame\"]>div[class*=\"bg-grid\"]{display:none}figure[data-name=\"frame\"]>div[class*=\"justify-center\"]{overflow:visible;border-radius:0}figure[data-name=\"frame\"] img{border-radius:0.375rem;box-shadow:0 0 0 0.5px #d4d4d8,\n 0 1px 2px 0 rgb(0 0 0 / 5%)}html.dark figure[data-name=\"frame\"] img{box-shadow:0 0 0 0.5px #3f3f46,\n 0 1px 2px 0 rgb(0 0 0 / 30%)}figure[data-name=\"frame\"]>div[class*=\"pointer-events-none\"]{border-color:transparent}@media (max-width: 767px){figure[data-name=\"frame\"]{padding:0.75rem!important}}html[data-current-path=\"/introduction\"] .card-group,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center){row-gap:0.5rem!important}html[data-current-path=\"/introduction\"] .card-group>.card,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center)>.card{margin-block:0!important}.template-meta{display:grid;grid-template-columns:7.5rem minmax(0, 1fr);gap:0.5rem 1rem;margin:0 0 1.5rem;padding:1.25rem;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:#fafafa}.template-meta-label{margin:0;font-weight:500;color:#71717a}.template-meta-value{margin:0}html.dark .template-meta{background:#18181b}html.dark .template-meta-label{color:#a1a1aa}@media (max-width: 639px){.template-meta{grid-template-columns:minmax(0, 1fr);gap:0.25rem;padding:1rem}.template-meta-value:not(:last-child){margin-bottom:0.5rem}}"}],"page":{"pagePath":"features/connectors/bigquery","slug":"/features/connectors/bigquery","pageMetadata":{"title":"BigQuery","description":"Connect Summation to a Google BigQuery project.","href":"/features/connectors/bigquery"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Connect Summation to a Google BigQuery project.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,ol:`ol`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table,Tip,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`Summation reads from BigQuery as a Google Cloud `,_jsx(_components.strong,{children:`service account`}),`. You configure the project to bill jobs to and paste the service account’s JSON key.`]}),`\n`,_jsx(Heading,{level:`2`,id:`what-you’ll-need`,children:`What you’ll need`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A `,_jsx(_components.strong,{children:`GCP project ID`}),` containing (or with access to) the data you want to expose. See `,_jsx(_components.a,{href:`https://cloud.google.com/resource-manager/docs/creating-managing-projects#identifying_projects`,children:`Identifying projects`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A `,_jsx(_components.strong,{children:`service account`}),` in that project. See `,_jsx(_components.a,{href:`https://cloud.google.com/iam/docs/service-accounts-create`,children:`Create service accounts`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A `,_jsx(_components.strong,{children:`JSON key`}),` for the service account. See `,_jsx(_components.a,{href:`https://cloud.google.com/iam/docs/keys-create-delete`,children:`Create and delete service account keys`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Three IAM roles for the service account:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`roles/bigquery.jobUser`}),` on the project: lets Summation run queries.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`roles/bigquery.dataViewer`}),` on each dataset (or the project): lets Summation read data.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`roles/bigquery.readSessionUser`}),` on the project: required. Summation reads via Arrow / the `,_jsx(_components.a,{href:`https://cloud.google.com/bigquery/docs/reference/storage`,children:`BigQuery Storage API`}),`, which creates read sessions.`]}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`All three roles are documented under `,_jsx(_components.a,{href:`https://cloud.google.com/bigquery/docs/access-control`,children:`BigQuery IAM roles and permissions`}),`.`]}),`\n`]}),`\n`]}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[`Grant `,_jsx(_components.code,{children:`bigquery.dataViewer`}),` on individual datasets rather than at the project level to limit Summation’s read scope to exactly what you intend.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`form-fields`,children:`Form fields`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Field`}),_jsx(_components.th,{children:`Required`}),_jsx(_components.th,{children:`Stored as`}),_jsx(_components.th,{children:`Notes`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Project ID`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`The GCP project Summation runs jobs in, e.g. `,_jsx(_components.code,{children:`my-gcp-project-123`}),`. See `,_jsx(_components.a,{href:`https://cloud.google.com/resource-manager/docs/creating-managing-projects#identifying_projects`,children:`Identifying projects`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Dataset ID`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`Default dataset for attached tables whose source reference does not name one. It does `,_jsx(_components.em,{children:`not`}),` restrict browsing; you can browse and attach tables from any dataset the service account can read, whatever this is set to. See `,_jsx(_components.a,{href:`https://cloud.google.com/bigquery/docs/datasets-intro`,children:`Datasets overview`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Location`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`BigQuery region, e.g. `,_jsx(_components.code,{children:`US`}),`, `,_jsx(_components.code,{children:`EU`}),`, `,_jsx(_components.code,{children:`us-east4`}),`. Collected by the form but not currently applied when browsing or reading, so setting it does not change which datasets are reachable. See `,_jsx(_components.a,{href:`https://cloud.google.com/bigquery/docs/locations`,children:`Dataset locations`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Service Account JSON`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Secret`}),_jsxs(_components.td,{children:[`The full contents of the JSON key file (including the surrounding `,_jsx(_components.code,{children:`{`}),` and `,_jsx(_components.code,{children:`}`}),`).`]})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`creating-the-service-account`,children:`Creating the service account`}),`\n`,_jsx(Heading,{level:`3`,id:`in-the-gcp-console`,children:`In the GCP Console`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Open `,_jsx(_components.a,{href:`https://console.cloud.google.com/iam-admin/serviceaccounts`,children:`IAM \u0026 Admin → Service Accounts`}),` for the project.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Create Service Account`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Enter a name (for example `,_jsx(_components.code,{children:`summation`}),`) and click `,_jsx(_components.strong,{children:`Create and Continue`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`On `,_jsx(_components.strong,{children:`Grant this service account access`}),`, add these three roles, then click `,_jsx(_components.strong,{children:`Continue`}),` and `,_jsx(_components.strong,{children:`Done`}),`:`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Role`}),_jsx(_components.th,{children:`Purpose`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`BigQuery Job User`}),` (`,_jsx(_components.code,{children:`roles/bigquery.jobUser`}),`)`]}),_jsx(_components.td,{children:`Run queries in the project`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`BigQuery Data Viewer`}),` (`,_jsx(_components.code,{children:`roles/bigquery.dataViewer`}),`)`]}),_jsx(_components.td,{children:`Read tables and datasets`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`BigQuery Read Session User`}),` (`,_jsx(_components.code,{children:`roles/bigquery.readSessionUser`}),`)`]}),_jsx(_components.td,{children:`Required for Arrow / Storage API reads`})]})]})]}),`\n`,_jsxs(_components.p,{children:[`If you prefer to scope `,_jsx(_components.strong,{children:`Data Viewer`}),` to individual datasets, skip it here and grant it per dataset after the account exists.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Open the new service account → `,_jsx(_components.strong,{children:`Keys`}),` → `,_jsx(_components.strong,{children:`Add Key`}),` → `,_jsx(_components.strong,{children:`Create new key`}),` → `,_jsx(_components.strong,{children:`JSON`}),`. The downloaded `,_jsx(_components.code,{children:`.json`}),` file is the credential for the form.`]}),`\n`]}),`\n`]}),`\n`,_jsx(Heading,{level:`3`,id:`with-gcloud`,children:`With gcloud`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`25`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`25`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`PROJECT_ID=my-gcp-project-123`})}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`gcloud iam service-accounts create summation \\\\`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --project=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"$PROJECT_ID\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --display-name=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Summation\"`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Lets Summation run queries in the project`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`gcloud projects add-iam-policy-binding `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"$PROJECT_ID\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --member=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"serviceAccount:summation@$PROJECT_ID.iam.gserviceaccount.com\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --role=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"roles/bigquery.jobUser\"`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Required: Summation reads via Arrow / Storage API read sessions`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`gcloud projects add-iam-policy-binding `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"$PROJECT_ID\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --member=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"serviceAccount:summation@$PROJECT_ID.iam.gserviceaccount.com\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --role=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"roles/bigquery.readSessionUser\"`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Repeat per dataset you want to expose`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`bq add-iam-policy-binding \\\\`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --member=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"serviceAccount:summation@$PROJECT_ID.iam.gserviceaccount.com\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --role=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"roles/bigquery.dataViewer\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \\\\`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"$PROJECT_ID:analytics\"`})}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Generate a JSON key, paste it into the form, then delete the local copy`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`gcloud iam service-accounts keys create summation-key.json \\\\`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` --iam-account=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"summation@$PROJECT_ID.iam.gserviceaccount.com\"`})]}),`\n`]})})}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`The downloaded `,_jsx(_components.code,{children:`summation-key.json`}),` is a credential. Paste it into Summation, then delete the local copy. See `,_jsx(_components.a,{href:`https://cloud.google.com/iam/docs/best-practices-for-managing-service-account-keys`,children:`Best practices for managing service account keys`}),`.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`adding-datasets`,children:`Adding datasets`}),`\n`,_jsx(_components.p,{children:`After saving the connection, browse the project’s BigQuery datasets and select tables or views. Source references use the form:`}),`\n`,_jsx(CodeBlock,{numberOfLines:`2`,language:`text`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`text`,children:_jsxs(_components.code,{language:`text`,numberOfLines:`2`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`adbc:dataset_id.table_name`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})})]})})}),`\n`,_jsx(Heading,{level:`2`,id:`common-problems`,children:`Common problems`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Error or symptom`}),_jsx(_components.th,{children:`Likely cause`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`Access Denied: Project ... User does not have bigquery.jobs.create permission`})}),_jsxs(_components.td,{children:[`Grant `,_jsx(_components.code,{children:`roles/bigquery.jobUser`}),` on the project.`]})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`Access Denied`}),` on `,_jsx(_components.code,{children:`bigquery.readsessions.create`}),`, Arrow, or Storage API`]}),_jsxs(_components.td,{children:[`Grant `,_jsx(_components.code,{children:`roles/bigquery.readSessionUser`}),` on the project. Job User and Data Viewer are not sufficient.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`Not found: Dataset ...`})}),_jsxs(_components.td,{children:[`The service account can’t see the dataset (grant `,_jsx(_components.code,{children:`roles/bigquery.dataViewer`}),` on it), or the dataset name is wrong. Setting `,_jsx(_components.strong,{children:`Location`}),` does not resolve this; it isn’t applied when browsing or reading.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`Invalid JSON`})}),_jsxs(_components.td,{children:[`Paste the full file contents including the surrounding `,_jsx(_components.code,{children:`{`}),` and `,_jsx(_components.code,{children:`}`}),`. Don’t escape or wrap the JSON.`]})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"BigQuery","description":"Connect Summation to a Google BigQuery project.","href":"/features/connectors/bigquery"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"What you’ll need","slug":"what-you’ll-need","depth":2,"children":[]},{"title":"Form fields","slug":"form-fields","depth":2,"children":[]},{"title":"Creating the service account","slug":"creating-the-service-account","depth":2,"children":[{"title":"In the GCP Console","slug":"in-the-gcp-console","depth":3,"children":[]},{"title":"With gcloud","slug":"with-gcloud","depth":3,"children":[]}]},{"title":"Adding datasets","slug":"adding-datasets","depth":2,"children":[]},{"title":"Common problems","slug":"common-problems","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/summation-676748f5/109fb4ec55c4f518/theme-toggle.js","/_mintlify/custom/summation-676748f5/767147eed46ae967/toc-indicator.js","/_mintlify/custom/summation-676748f5/82e2d1909a80e450/sidebar-collapse.js"],"subdomain":"summation-676748f5","siteName":"Summation","title":"BigQuery - Summation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-09-14T04:09:54.572Z","originalFileLocation":"features/connectors/bigquery.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Connect Summation to a Google BigQuery project.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Summation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"BigQuery - Summation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Connect Summation to a Google BigQuery project.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Summation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.summation.com/features/connectors/bigquery\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Connectors\u0026amp;title=BigQuery\u0026amp;description=Connect+Summation+to+a+Google+BigQuery+project.\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=90e40827ea1e91c64d3bf5237ac815bafdf9eb0574ccbe34fc5ba091d9d7922f\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"BigQuery - Summation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Connect Summation to a Google BigQuery project.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Connectors\u0026amp;title=BigQuery\u0026amp;description=Connect+Summation+to+a+Google+BigQuery+project.\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=90e40827ea1e91c64d3bf5237ac815bafdf9eb0574ccbe34fc5ba091d9d7922f\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Summation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#000000\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.summation.com/features/connectors/bigquery\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/features/connectors/bigquery.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.summation.com/#organization\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.summation.com#website\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.summation.com/features/connectors/bigquery#webpage\",\"url\":\"https://docs.summation.com/features/connectors/bigquery\",\"name\":\"BigQuery\",\"description\":\"Connect Summation to a Google BigQuery project.\",\"dateModified\":\"2026-09-14T04:09:54.572Z\",\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.summation.com/features/connectors/bigquery#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.summation.com/features/connectors/bigquery#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Connectors\",\"item\":\"https://docs.summation.com/features/connectors\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BigQuery\",\"item\":\"https://docs.summation.com/features/connectors/bigquery\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.summation.com/features/connectors/bigquery#article\",\"headline\":\"BigQuery\",\"name\":\"BigQuery\",\"description\":\"Connect Summation to a Google BigQuery project.\",\"url\":\"https://docs.summation.com/features/connectors/bigquery\",\"mainEntityOfPage\":{\"@id\":\"https://docs.summation.com/features/connectors/bigquery#webpage\"},\"dateModified\":\"2026-09-14T04:09:54.572Z\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Summation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Summation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/features/connectors/bigquery.md","siteName":"Summation","nav":{"global":null,"tabs":[{"tab":"Documentation","icon":"book-open","groups":[{"group":"Get started","pages":[{"title":"What is Summation?","href":"/introduction"},{"title":"Connect your data","sidebarTitle":"1. Connect your data","href":"/get-started/connect-your-data"},{"title":"Create your first analysis","sidebarTitle":"2. Create your first analysis","href":"/get-started/first-artifact"},{"title":"Refine your business context","sidebarTitle":"3. Refine your business context","href":"/get-started/build-your-context"},{"title":"Automate your first workflow","sidebarTitle":"4. Automate your first workflow","href":"/get-started/first-workflow"}]},{"group":"Key concepts","pages":[{"title":"Addison","href":"/features/addison"},{"title":"Projects","href":"/features/projects"},{"group":"Artifacts","pages":[{"title":"Verified Artifacts","sidebarTitle":"Overview","href":"/features/artifacts"},{"title":"Verification","href":"/features/artifacts/verification"},{"title":"Reports","href":"/features/artifacts/reports"},{"title":"Dashboards","href":"/features/artifacts/dashboards"},{"title":"Decks","href":"/features/artifacts/decks"},{"title":"Playbooks","href":"/features/artifacts/playbooks"},{"title":"Excel","href":"/features/artifacts/excel"},{"title":"HTML","href":"/features/artifacts/html"}]},{"title":"Workflows","href":"/features/workflows"},{"title":"Applications","href":"/features/applications"},{"group":"Tables","pages":[{"title":"Tables","sidebarTitle":"Overview","href":"/features/tables"},{"title":"Data table","href":"/features/tables/data"},{"title":"Source table","href":"/features/tables/source"},{"title":"Calculation table","href":"/features/tables/calculation"},{"title":"Dimension table","href":"/features/tables/dimension"},{"title":"Views","href":"/features/tables/views"}]},{"title":"Knowledge","href":"/features/knowledge"},{"title":"Skills","href":"/features/skills"}]},{"group":"Connectors","pages":[{"title":"Connectors","sidebarTitle":"Overview","href":"/features/connectors"},{"title":"Apps","href":"/features/connectors/apps"},{"title":"Snowflake","description":"Connect Summation to a Snowflake account.","href":"/features/connectors/snowflake"},{"title":"BigQuery","href":"/features/connectors/bigquery"},{"title":"Databricks","description":"Connect Summation to Databricks via SQL Warehouse, Spark Connect, or direct Delta Lake.","href":"/features/connectors/databricks"},{"title":"Postgres","href":"/features/connectors/postgres"},{"title":"Redshift","href":"/features/connectors/redshift"},{"title":"MySQL","href":"/features/connectors/mysql"},{"title":"SQL Server","href":"/features/connectors/mssql"},{"title":"ClickHouse","href":"/features/connectors/clickhouse"},{"title":"MongoDB","href":"/features/connectors/mongodb"},{"title":"Oracle","href":"/features/connectors/oracle"},{"title":"MotherDuck","href":"/features/connectors/motherduck"},{"title":"REST API","href":"/features/connectors/http"},{"title":"Datadog","href":"/features/connectors/datadog"},{"title":"S3","href":"/features/connectors/s3"},{"title":"Apache Iceberg","href":"/features/connectors/iceberg"},{"title":"AWS Glue","href":"/features/connectors/glue"},{"title":"GCS","href":"/features/connectors/gcs"},{"title":"Google Sheets","href":"/features/connectors/google-sheets"},{"title":"GitHub","href":"/features/connectors/github"}]},{"group":"Agent integrations","pages":[{"title":"Claude Plugin","href":"/integrations/claude-plugin"},{"title":"Codex Plugin","href":"/integrations/codex-plugin"},{"title":"MCP Server","href":"/integrations/mcp-server"}]}]},{"tab":"Use cases","icon":"lightbulb","pages":[{"title":"Use cases","href":"/use-cases/overview"}]},{"tab":"API","icon":"code","pages":[{"title":"API","href":"/api/overview"}]}]},"basePath":"","title":"BigQuery - Summation","deploymentId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","buildId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","dynamics":[],"chunks":[]}