Google BigQuery
Databases & warehousesOAuth 2.0credential probe
BigQuery — run standard-SQL and stream rows (Google OAuth2).
OCNORA ships 39 typed Google BigQuery operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.
Operations 39
- Batch Delete Row Access PolicyDeletes provided row access policies.bigquery.batch_delete_row_access_policy
- Cancel JobRequests that a job be cancelled.bigquery.cancel_job
- Create DatasetCreates a new empty dataset.bigquery.create_dataset
- Create JobStarts a new asynchronous job.bigquery.create_job
- Create RoutineCreates a new routine in the dataset.bigquery.create_routine
- Create Row Access PolicyCreates a row access policy.bigquery.create_row_access_policy
- Create TableCreate a BigQuery table from a JSON schema of {name, type, mode} fields.bigquery.create_table
- Delete DatasetDeletes the dataset specified by the datasetId value.bigquery.delete_dataset
- Delete JobRequests the deletion of the metadata of a job.bigquery.delete_job
- Delete ModelDeletes the model specified by modelId from the dataset.bigquery.delete_model
- Delete RoutineDeletes the routine specified by routineId from the dataset.bigquery.delete_routine
- Delete Row Access PolicyDeletes a row access policy.bigquery.delete_row_access_policy
- Delete TableDelete a BigQuery table.bigquery.delete_table
- Get DatasetReturns the dataset specified by datasetID.bigquery.get_dataset
- Get JobReturns information about a specific job.bigquery.get_job
- Get ModelGets the specified model resource by model ID.bigquery.get_model
- Get Query Results JobRPC to get the results of a query job.bigquery.get_query_results_job
- Get RoutineGets the specified routine resource by routine ID.bigquery.get_routine
- Get Row Access PolicyGets the specified row access policy by policy ID.bigquery.get_row_access_policy
- Get Service Account ProjectRPC to get the service account for a project used for interactions with Google Cloud KMS.bigquery.get_service_account_project
- Get TableRead a BigQuery table's schema, row count and size.bigquery.get_table
- Insert RowsStream rows into a BigQuery table (insertAll).bigquery.insert_rows
- List DatasetsList the BigQuery datasets in a GCP project.bigquery.list_datasets
- List JobsLists all jobs that you started in the specified project.bigquery.list_jobs
- List ModelsLists all models in the specified dataset.bigquery.list_models
- List ProjectsRPC to list projects to which the user has been granted any project role.bigquery.list_projects
- List RoutinesLists all routines in the specified dataset.bigquery.list_routines
- List Row Access PoliciesLists all row access policies on the specified table.bigquery.list_row_access_policies
- List TabledataList the content of a table in rows.bigquery.list_tabledata
- List TablesList the tables and views in a BigQuery dataset.bigquery.list_tables
- Run QueryRun a standard-SQL query in BigQuery and return the rows.bigquery.query
- Replace DatasetUpdates information in an existing dataset.bigquery.replace_dataset
- Replace RoutineUpdates information in an existing routine.bigquery.replace_routine
- Replace Row Access PolicyUpdates a row access policy.bigquery.replace_row_access_policy
- Replace TableUpdates information in an existing table.bigquery.replace_table
- Undelete DatasetUndeletes a dataset which is within time travel window based on datasetId.bigquery.undelete_dataset
- Update DatasetUpdates information in an existing dataset.bigquery.update_dataset
- Update ModelPatch specific fields in the specified model.bigquery.update_model
- Update TableUpdates information in an existing table.bigquery.update_table
More in Databases & warehouses
Run your first Google BigQuery workflow today.
Create a free workspace, add the connection, pick a template or describe the workflow to Build with AI. Workflow Health checks it before it runs.