Duaer

Integrations

Use Google BigQuery in Duaer

In Duaer, the Google BigQuery node works with Google BigQuery from a workflow. It offers 2 operations: Execute Query and Insert.

Add Google BigQuery to a Duaer workflow

  1. On the Duaer canvas, open the node panel, search for Google BigQuery, and connect it after the previous node.
  2. Under Authentication, choose OAuth2 (recommended) or Service Account, then pick or create the matching credential (Google Service Account API or Google BigQuery OAuth2 API) in Credential to connect with. Refer to Google BigQuery credentials.
  3. Pick an Operation, for example Execute Query.
  4. Select Execute step and check the output.

Google BigQuery operations in Duaer

  • Execute Query: Execute a SQL query.
  • Insert: Insert rows in a table.

Use Google BigQuery as a tool for an AI Agent in Duaer

In the Tool input of an AI Agent, search for Google BigQuery and add it. The agent decides when to call it. For a field the model should fill, select the sparkle next to it or write $fromAI('name', 'what to put here'); fixed values stay as you set them.

Call a Google BigQuery endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Google Service Account API as the credential type, and select the same credential. Duaer signs the request with it, so you only fill in the method and URL. Refer to custom operations.

Questions

What can the Google BigQuery node do in Duaer?

In Duaer, Google BigQuery offers Execute Query and Insert.

Which credential does Google BigQuery use in Duaer?

Duaer's Google BigQuery uses Google Service Account API or Google BigQuery OAuth2 API, depending on the method you choose under Authentication.

In this section