Google BigQuery
Disponible32 accionesOAuthDatos y analíticaHerramientas para desarrolladoresAbrir el sitio web de 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.
Lo que tu agente puede hacer en Google BigQuery
Acciones agrupadas por tarea. Cada grupo enumera las acciones que llama.
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 más
Tareas para tu agente
Completa lo que está entre corchetes y conecta la segunda app que nombre la tarea, si la hay.
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].
También necesitaGoogle Sheets
Acciones32
Todas las acciones que ofrece el conector de Google BigQuery, por nombre e 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.
Cómo inicia sesión Google BigQuery
- Método de inicio de sesión
- OAuthAuthorize your Google account for BigQuery.
- Necesitas
- A Google account with the required BigQuery project and resource permissions.
- Notas
- Supply the project and job region. Query execution may incur BigQuery usage charges; Cloud Storage transfers require relevant storage access.
Preguntas sobre el conector de Google BigQuery
Conectores que se usan con Google BigQuery
Otras apps a las que también llaman las tareas con Google BigQuery.