> ## Documentation Index
> Fetch the complete documentation index at: https://hoopdev-docs-improve-idp-sso-pages.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery

> A fully managed, serverless data warehouse that enables super-fast SQL queries using Google's infrastructure.

<ConnectionTemplate
  config={{
"id": "bigquery",
"name": "BigQuery",
"description": "A fully managed, serverless data warehouse that enables super-fast SQL queries using Google's infrastructure.",
"category": "databases",
"icon-name": "google-bigquery",
"tags": [
"database",
"analytics",
"google-cloud",
"sql"
],
"features": {
"tlsTerminationProxy": {
  "native": false,
  "oneOff": true
},
"audit": {
  "native": false,
  "oneOff": true
},
"dataMaskingGoogleDLP": {
  "native": false,
  "oneOff": true
},
"dataMaskingMSPresidio": {
  "native": false,
  "oneOff": true
},
"guardrails": {
  "native": false,
  "oneOff": true
},
"credentialsOffload": {
  "native": false,
  "oneOff": true
},
"interactiveAccess": {
  "native": false,
  "oneOff": false
}
},
"requirements": {
"description": "The Google Service Account Credentials must have the following permissions:",
"items": [
  "BigQuery User",
  "BigQuery Data Viewer"
]
},
"overview": {
"description": "Connect to BigQuery through Hoop.dev for secure analytics access with automated data classification, query monitoring, and intelligent cost controls. Execute petabyte-scale queries while protecting sensitive datasets with zero-config data masking."
},
"setupGuide": {
"accessMethods": {
  "webapp": true,
  "cli": false,
  "runbooks": true
}
},
"resourceConfiguration": {
"type": "custom",
"subtype": "bigquery",
"command": [
  "bq",
  "query",
  "--use_legacy_sql=false",
  "--format=prettyjson",
  "--project_id=$CLOUDSDK_CORE_PROJECT"
],
"credentials": [
  {
    "name": "GOOGLE_APPLICATION_CREDENTIALS",
    "type": "filesystem",
    "required": true,
    "description": "The service account credentials file in JSON format",
    "placeholder": "file content of service-account.json"
  },
  {
    "name": "CLOUDSDK_CORE_PROJECT",
    "type": "env-var",
    "required": true,
    "description": "The project id to use for request",
    "placeholder": "my-project-id"
  }
]
},
"documentationConfig": {
"path": "quickstart/databases/bigquery"
}
}}
/>