Skip to content

BIGQUERY.md

Latest commit

 

History

History
27 lines (19 loc) · 1.49 KB

BIGQUERY.md

File metadata and controls

27 lines (19 loc) · 1.49 KB

Setup

Required Gemini CLI Version

To install this extension, the Gemini CLI version must be v0.6.0 or above. The version can be found by running: gemini --version.

BigQuery MCP Server (Data Plane: Connecting and Querying)

This section covers connecting to a BigQuery instance.

  1. Verify Environment Variables: Before attempting to connect, confirm with the user that the following environment variables are set in the extension configuration or their shell environment.

    • BIGQUERY_PROJECT: The GCP project ID.

  2. Handle Missing Variables: If a command fails with an error message containing a placeholder like ${BIGQUERY_PROJECT}, it signifies a missing environment variable. Inform the user which variable is missing and instruct them to set it.

  3. Handle Permission Errors:

    • For operations that execute queries and view metadata, the user needs the BigQuery User (roles/bigquery.user) and BigQuery Metadata Viewer (roles/bigquery.metadataViewer) role.
    • For operations that create, or modify datasets and tables, the user neds the BigQuery Data Editor (roles/bigquery.dataEditor) role.
    • If an operation fails due to permissions, identify the type of operation and recommend the appropriate role. you can provide these links for assistance: