Google BigQuery
Analytics & dataOAuth 2.0
Query and manage BigQuery datasets, tables and jobs in Google Cloud.
13 actions
| Action | Effect | Data handled | Scope |
|---|---|---|---|
| google_bigquery_list_projectsLists the Google Cloud projects the user can use with BigQuery | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_list_datasetsLists the datasets of a project | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_get_datasetGets a dataset with its location, description, labels and access | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_create_datasetCreates a dataset in a project | write | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_list_tablesLists the tables and views of a dataset | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_get_tableGets a table's schema, row count, size and partitioning | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_run_queryRuns a GoogleSQL query and returns the first page of rows keyed by column name | write | Personal data | https://www.googleapis.com/auth/bigquery |
| google_bigquery_get_query_resultsReads the rows of a query job, waiting for it to finish or paging through results | read | Personal data | https://www.googleapis.com/auth/bigquery |
| google_bigquery_list_table_rowsReads rows straight from a table without running a query, which costs nothing | read | Personal data | https://www.googleapis.com/auth/bigquery |
| google_bigquery_insert_rowsStreams rows into a table | write | Personal data | https://www.googleapis.com/auth/bigquery |
| google_bigquery_list_jobsLists recent jobs of a project, newest first | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_get_jobGets a job's status, statistics and errors | read | General | https://www.googleapis.com/auth/bigquery |
| google_bigquery_cancel_jobRequests cancellation of a running job | write | General | https://www.googleapis.com/auth/bigquery |