Google BigQuery
Databases & warehousesOAuth 2.0Connection test available
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.
Before you connect Google BigQuery
- Authentication
- OAuth 2.0
- Credential
- {"client_id", "client_secret", "refresh_token"}
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Google BigQuery
Operations, grouped by what they do to your data.
Create and send 7
Read and search 16
Delete and cancel 7
A sample Google BigQuery workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Google BigQuery trigger is needed.
- 2Get Datasetbigquery.get_datasetReturns the dataset specified by datasetID.
- 3Batch Delete Row Access Policybigquery.batch_delete_row_access_policyDeletes provided row access policies.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
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
Google BigQuery questions
- How does OCNORA authenticate with Google BigQuery?
- With a stored OAuth 2.0 credential, shaped {"client_id", "client_secret", "refresh_token"}. A connection test can check it when you add it.
- What can I automate with Google BigQuery?
- 39 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Google BigQuery operation I need is not listed?
- Where Google BigQuery has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Google BigQuery?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Google BigQuery calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
More in Databases & warehouses
See your first Google BigQuery workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.