Connect Hermes to Google BigQuery and Notion

Run a SQL query and return results inline (synchronous, bounded by timeout).

Page through the results of a (possibly async) query job.

Start a query / load / extract / copy job (async).

Fetch a job's status and statistics (poll until DONE).

List jobs in a project (filter by state, time range).

Request cancellation of a running job.

Delete a job's metadata.

List datasets in the project.

Fetch dataset metadata.

Create a new dataset.

Full replace of dataset metadata (PUT).

Partial update of dataset metadata (PATCH).

Delete a dataset.

List tables/views in a dataset.

Fetch table metadata/schema.

Create a table or view with a schema.

Partial update of a table (add columns, set expiration, etc.).

Full replace of table metadata (PUT).

Delete a table or view.

Streaming insert of JSON rows into a table (real-time append).

Read rows from a table directly (paginated, no SQL).

List stored procedures / UDFs / TVFs in a dataset.

Fetch a routine definition.

Create a stored procedure / UDF / TVF.

List BigQuery ML models in a dataset.

Fetch BQML model metadata.

Delete a BQML model.

Return the BigQuery service account for the project (KMS/transfer grants).

List projects the caller can access (for project picker UIs).

Restore a dataset within its time-travel window (datasets.undelete).

Replace a routine's full definition (routines.update, PUT).

Delete a routine (routines.delete).

Update mutable BQML model metadata (models.patch).

Get the IAM policy for a table (tables.getIamPolicy).

Set the IAM policy for a table (tables.setIamPolicy).

Test the caller's permissions on a table (tables.testIamPermissions).

List row access policies on a table (rowAccessPolicies.list).

Get a single row access policy (rowAccessPolicies.get).

Search pages and databases by title

Query a database to retrieve pages

Retrieve a database's metadata and schema

Create a new database as a child of a page

Update a database's title, description, or properties

Retrieve a page's properties

Retrieve a single property value from a page

Create a new page in a database or as a child of another page

Update a page's properties, icon, or cover

Retrieve a block

Retrieve a block's children

Append new children blocks to a parent block

Update a block's content

Delete (archive) a block

List all users in the workspace

Retrieve a user by ID

Retrieve the bot user for the current integration

Create a comment on a page or in an existing discussion thread

Retrieve a comment by its ID

List comments on a block or page

Update a comment's rich text content

Delete a comment

List all views for a database

Retrieve a specific database view

Update a database view's name or layout

Initiate a file upload and get an upload URL

Get the status of an asynchronous Notion task