OCNORA

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 Policy
    Deletes provided row access policies.
    bigquery.batch_delete_row_access_policy
  • Cancel Job
    Requests that a job be cancelled.
    bigquery.cancel_job
  • Create Dataset
    Creates a new empty dataset.
    bigquery.create_dataset
  • Create Job
    Starts a new asynchronous job.
    bigquery.create_job
  • Create Routine
    Creates a new routine in the dataset.
    bigquery.create_routine
  • Create Row Access Policy
    Creates a row access policy.
    bigquery.create_row_access_policy
  • Create Table
    Create a BigQuery table from a JSON schema of {name, type, mode} fields.
    bigquery.create_table
  • Delete Dataset
    Deletes the dataset specified by the datasetId value.
    bigquery.delete_dataset
  • Delete Job
    Requests the deletion of the metadata of a job.
    bigquery.delete_job
  • Delete Model
    Deletes the model specified by modelId from the dataset.
    bigquery.delete_model
  • Delete Routine
    Deletes the routine specified by routineId from the dataset.
    bigquery.delete_routine
  • Delete Row Access Policy
    Deletes a row access policy.
    bigquery.delete_row_access_policy
  • Delete Table
    Delete a BigQuery table.
    bigquery.delete_table
  • Get Dataset
    Returns the dataset specified by datasetID.
    bigquery.get_dataset
  • Get Job
    Returns information about a specific job.
    bigquery.get_job
  • Get Model
    Gets the specified model resource by model ID.
    bigquery.get_model
  • Get Query Results Job
    RPC to get the results of a query job.
    bigquery.get_query_results_job
  • Get Routine
    Gets the specified routine resource by routine ID.
    bigquery.get_routine
  • Get Row Access Policy
    Gets the specified row access policy by policy ID.
    bigquery.get_row_access_policy
  • Get Service Account Project
    RPC to get the service account for a project used for interactions with Google Cloud KMS.
    bigquery.get_service_account_project
  • Get Table
    Read a BigQuery table's schema, row count and size.
    bigquery.get_table
  • Insert Rows
    Stream rows into a BigQuery table (insertAll).
    bigquery.insert_rows
  • List Datasets
    List the BigQuery datasets in a GCP project.
    bigquery.list_datasets
  • List Jobs
    Lists all jobs that you started in the specified project.
    bigquery.list_jobs
  • List Models
    Lists all models in the specified dataset.
    bigquery.list_models
  • List Projects
    RPC to list projects to which the user has been granted any project role.
    bigquery.list_projects
  • List Routines
    Lists all routines in the specified dataset.
    bigquery.list_routines
  • List Row Access Policies
    Lists all row access policies on the specified table.
    bigquery.list_row_access_policies
  • List Tabledata
    List the content of a table in rows.
    bigquery.list_tabledata
  • List Tables
    List the tables and views in a BigQuery dataset.
    bigquery.list_tables
  • Run Query
    Run a standard-SQL query in BigQuery and return the rows.
    bigquery.query
  • Replace Dataset
    Updates information in an existing dataset.
    bigquery.replace_dataset
  • Replace Routine
    Updates information in an existing routine.
    bigquery.replace_routine
  • Replace Row Access Policy
    Updates a row access policy.
    bigquery.replace_row_access_policy
  • Replace Table
    Updates information in an existing table.
    bigquery.replace_table
  • Undelete Dataset
    Undeletes a dataset which is within time travel window based on datasetId.
    bigquery.undelete_dataset
  • Update Dataset
    Updates information in an existing dataset.
    bigquery.update_dataset
  • Update Model
    Patch specific fields in the specified model.
    bigquery.update_model
  • Update Table
    Updates information in an existing table.
    bigquery.update_table

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.