Google BigQuery を Open Flow に接続
Get a scoped answer from your warehouse without manually assembling every query.
毎月 20,000 回のアプリ呼び出しが無料(有料サービスは別途課金)
アプリの説明と操作の詳細は英語で表示されます。
できること
Inspect tables and rows, run analytical queries, and manage supported data-transfer or table operations with your Google Cloud permissions.
Schemas and Table Data
Browse projects, datasets, tables, and rows for analysis.
SQL and Data Transfer Jobs
Run SQL, check jobs, and start Cloud Storage load or export jobs.
Dataset and Table Management
Create, revise, or delete datasets and tables, and insert rows with per-row error reporting.
Google BigQuery を使うテンプレート
すべての操作
List Projects
List Google Cloud projects accessible to BigQuery.
google_bigquery.list_projectsList Datasets
List BigQuery datasets in a Google Cloud project.
google_bigquery.list_datasetsGet Dataset
Retrieve BigQuery dataset metadata.
google_bigquery.get_datasetList Tables
List BigQuery tables in a dataset.
google_bigquery.list_tablesGet Table
Retrieve BigQuery table metadata, including schema when available.
google_bigquery.get_tableList Table Data
List rows from a BigQuery table.
google_bigquery.list_table_dataQuery
Run a BigQuery SQL query and return the first page of results.
google_bigquery.queryGet Query Results
Poll a BigQuery query job and return a page of results.
google_bigquery.get_query_resultsGet Job
Retrieve BigQuery job metadata.
google_bigquery.get_jobList Jobs
List BigQuery jobs in a Google Cloud project.
google_bigquery.list_jobsCancel Job
Cancel a BigQuery job.
google_bigquery.cancel_jobStart Query Job
Start an asynchronous BigQuery query job.
google_bigquery.start_query_jobStart Load Job From Gcs
Start an asynchronous BigQuery load job from Cloud Storage objects.
google_bigquery.start_load_job_from_gcsStart Extract Job To Gcs
Start an asynchronous BigQuery extract job to Cloud Storage objects.
google_bigquery.start_extract_job_to_gcsCreate Dataset
Create a BigQuery dataset.
google_bigquery.create_datasetPatch Dataset
Patch BigQuery dataset metadata.
google_bigquery.patch_datasetUpdate Dataset
Replace BigQuery dataset metadata with the supplied dataset resource fields.
google_bigquery.update_datasetDelete Dataset
Delete a BigQuery dataset, optionally deleting contained tables when explicitly requested.
google_bigquery.delete_datasetCreate Table
Create a BigQuery table.
google_bigquery.create_tablePatch Table
Patch BigQuery table metadata.
google_bigquery.patch_tableUpdate Table
Replace BigQuery table metadata with the supplied table resource fields.
google_bigquery.update_tableDelete Table
Delete a BigQuery table from a dataset.
google_bigquery.delete_tableInsert All
Insert a small batch of rows into a BigQuery table.
google_bigquery.insert_allList Routines
List BigQuery routines in a dataset.
google_bigquery.list_routinesGet Routine
Retrieve BigQuery routine metadata.
google_bigquery.get_routineCreate Routine
Create a BigQuery routine such as a user-defined function or stored procedure.
google_bigquery.create_routineUpdate Routine
Replace BigQuery routine metadata and definition fields.
google_bigquery.update_routineDelete Routine
Delete a BigQuery routine from a dataset.
google_bigquery.delete_routineList Models
List BigQuery ML models in a dataset.
google_bigquery.list_modelsGet Model
Retrieve BigQuery ML model metadata.
google_bigquery.get_modelPatch Model
Patch BigQuery ML model metadata such as friendly name, description, or labels.
google_bigquery.patch_modelDelete Model
Delete a BigQuery ML model from a dataset.
google_bigquery.delete_model検索条件に一致する操作はありません。
Google BigQuery を Open Flow に接続
毎月 20,000 回のアプリ呼び出しが無料(有料サービスは別途課金)

