What type of queries can I run?

You can run SELECT queries limited to a maximum of 1TB of data processing. The tool detects and rejects DML (data modification) statements.

What format are the query results returned in?

The query results are returned in a structured JSON format, making them easy to parse and integrate into other applications.

What is BigQuery Analysis?

BigQuery Analysis is a tool that executes SQL queries against Google BigQuery with validation, cost estimation, and safe execution limits.

How does the tool ensure query safety?

The tool uses a dry run feature to validate queries and estimate processing size. It also actively rejects DML statements to prevent data modifications.

How do I set up authentication?

You can authenticate using either the gcloud CLI or a service account key. Refer to the documentation for detailed instructions.

BigQuery Analysis

Name: BigQuery Analysis
Author: gotalab

bygotalab

•

分析と監視

データベース管理

データサイエンスとML

Executes SQL queries against Google BigQuery, providing query validation and safe execution features.

This server is designed to execute SQL queries against Google BigQuery with a focus on safety and validation. It performs query validation (dry run) to verify query validity and estimate processing size. It also ensures safe query execution by only running SELECT queries under 1TB to prevent unintended data modifications. Results are returned in a structured JSON format for easy integration.