Skip to content

bigquery.md

Latest commit

 

History

History
50 lines (48 loc) · 2.55 KB

bigquery.md

File metadata and controls

50 lines (48 loc) · 2.55 KB
Raw
title BigQuery
type docs
description Details of the BigQuery prebuilt configuration.

BigQuery

  • --prebuilt value: bigquery
  • Environment Variables:
    • BIGQUERY_PROJECT: The GCP project ID.
    • BIGQUERY_LOCATION: (Optional) The dataset location.
    • BIGQUERY_USE_CLIENT_OAUTH: (Optional) If true, forwards the client's OAuth access token for authentication. Defaults to false.
    • BIGQUERY_SCOPES: (Optional) A comma-separated list of OAuth scopes to use for authentication.
    • BIGQUERY_IMPERSONATE_SERVICE_ACCOUNT: (Optional) Service account email to impersonate when making BigQuery and Dataplex API calls. The authenticated principal must have roles/iam.serviceAccountTokenCreator on the target service account.
    • BIGQUERY_ENDPOINT: (Optional) Override the BigQuery API host (URL or host:port) for proxies, alternate front-ends, or local emulators. http endpoints are supported (e.g. http://localhost:9050). Unset or empty uses the default Google endpoint. (For the official local emulator, client libraries use the BIGQUERY_EMULATOR_HOST convention.)
  • Permissions:
    • BigQuery User (roles/bigquery.user) to execute queries and view metadata.
    • BigQuery Metadata Viewer (roles/bigquery.metadataViewer) to view all datasets.
    • BigQuery Data Editor (roles/bigquery.dataEditor) to create or modify datasets and tables.
    • Gemini for Google Cloud (roles/cloudaicompanion.user) to use the conversational analytics API.
  • Tools:
    • analyze_contribution: Use this tool to perform contribution analysis, also called key driver analysis.
    • ask_data_insights: Use this tool to perform data analysis, get insights, or answer complex questions about the contents of specific BigQuery tables. For more information on required roles, API setup, and IAM configuration, see the setup and authentication section of the Conversational Analytics API documentation.
    • execute_sql: Executes a SQL statement.
    • forecast: Use this tool to forecast time series data.
    • get_dataset_info: Gets dataset metadata.
    • get_table_info: Gets table metadata.
    • list_dataset_ids: Lists datasets.
    • list_table_ids: Lists tables.
    • search_catalog: Search for entries based on the provided query.