Google BigQuery
Ask AI to inspect BigQuery tables, run scoped analytical queries, and save summaries in Google Sheets.
Inspect tables and rows, run analytical queries, and manage supported data-transfer or table operations with your Google Cloud permissions.
エージェントが Google BigQuery でできること
アクションをタスク別にまとめ、各グループに呼び出すアクションを記載しています。
Schemas and Table Data
Browse projects, datasets, tables, and rows for analysis.
- List Projects
- List Datasets
- Get Dataset
- List Tables
- Get Table
- List Table Data
SQL and Data Transfer Jobs
Run SQL, check jobs, and start Cloud Storage load or export jobs.
- Query
- Get Query Results
- Start Query Job
- Get Job
- List Jobs
- Cancel Job
- Start Load Job From Gcs
- Start Extract Job To Gcs
Dataset and Table Management
Create, revise, or delete datasets and tables, and insert rows with per-row error reporting.
- Create Dataset
- Patch Dataset
- Update Dataset
- Delete Dataset
- Create Table
- Patch Table
- Update Table
- Delete Table
- ほか 1 件
エージェントに任せられるタスク
かっこ内を埋め、タスクに 2 つ目のアプリがあればそれも接続してください。
Inspect a Dataset Before Querying
Read tables and their schemas to understand the available data.
Inspect dataset [dataset] in project [project]. Explain which tables and columns can answer [question].
Answer a Data Question with SQL
Execute a read-only SQL query and summarize completed results.
In project [project], region [region], use table [table] to answer [question] for [date range]. Run a read-only query and summarize the completed results.
Save Query Results in Google Sheets
Put a completed warehouse summary into a spreadsheet your team can review.
In BigQuery project [project] and region [region], use [table] to summarize [question] for [date range]. Save the completed summary in [spreadsheet link], worksheet [name], replacing only [target cell range].
ほかに必要Google Sheets
アクション32
Google BigQuery コネクタが提供するすべてのアクションを、名前と ID で掲載しています。
- List Projects
list_projectsList Google Cloud projects accessible to BigQuery. - List Datasets
list_datasetsList BigQuery datasets in a Google Cloud project. - Get Dataset
get_datasetRetrieve BigQuery dataset metadata. - List Tables
list_tablesList BigQuery tables in a dataset. - Get Table
get_tableRetrieve BigQuery table metadata, including schema when available. - List Table Data
list_table_dataList rows from a BigQuery table. - Query
queryRun a BigQuery SQL query and return the first page of results. - Get Query Results
get_query_resultsPoll a BigQuery query job and return a page of results. - Get Job
get_jobRetrieve BigQuery job metadata. - List Jobs
list_jobsList BigQuery jobs in a Google Cloud project. - Cancel Job
cancel_jobCancel a BigQuery job. - Start Query Job
start_query_jobStart an asynchronous BigQuery query job. - Start Load Job From Gcs
start_load_job_from_gcsStart an asynchronous BigQuery load job from Cloud Storage objects. - Start Extract Job To Gcs
start_extract_job_to_gcsStart an asynchronous BigQuery extract job to Cloud Storage objects. - Create Dataset
create_datasetCreate a BigQuery dataset. - Patch Dataset
patch_datasetPatch BigQuery dataset metadata. - Update Dataset
update_datasetReplace BigQuery dataset metadata with the supplied dataset resource fields. - Delete Dataset
delete_datasetDelete a BigQuery dataset, optionally deleting contained tables when explicitly requested. - Create Table
create_tableCreate a BigQuery table. - Patch Table
patch_tablePatch BigQuery table metadata.
Google BigQuery のサインイン方法
- サインイン方法
- OAuthAuthorize your Google account for BigQuery.
- 必要なもの
- A Google account with the required BigQuery project and resource permissions.
- 備考
- Supply the project and job region. Query execution may incur BigQuery usage charges; Cloud Storage transfers require relevant storage access.
Google BigQuery コネクタに関するよくある質問
Google BigQuery と一緒に使われるコネクタ
Google BigQuery を使うタスクがほかに呼び出すアプリ。