Google BigQuery IK icon

Google BigQuery IK

Consume Google BigQuery API (added support for query operation)

Actions3

Overview

This n8n node, Google BigQuery IK, enables interaction with the Google BigQuery API. It allows users to perform operations such as inserting records, retrieving data, and executing queries on BigQuery tables directly from n8n workflows. This node is particularly useful for automating data ingestion, extraction, and transformation tasks involving BigQuery datasets.

Common scenarios:

  • Automating the insertion of new rows into a BigQuery table.
  • Fetching all or filtered records from a table for reporting or further processing.
  • Running custom SQL queries against BigQuery and using the results in downstream workflow steps.

Practical examples:

  • Periodically importing data from another system into BigQuery.
  • Extracting analytics data from BigQuery to send summary reports via email.
  • Triggering complex data transformations by running parameterized queries.

Properties

Name Type Meaning
Authentication options Selects the authentication method: OAuth2 (recommended) or Service Account.

Note: The node also supports additional properties (not listed here) for specifying project, dataset, table, query, and other operation-specific parameters.

Output

  • For successful operations, the output is an array of objects under the json field, each representing a row or result returned by BigQuery.
  • In case of errors (when "Continue On Fail" is enabled), the output will include an object with an error property containing the error message.
  • If the "Simple" option is enabled, the output is simplified to only include selected fields from the result rows.

Example output (success):

[
  {
    "json": {
      "column1": "value1",
      "column2": "value2"
    }
  }
]

Example output (error):

[
  {
    "json": {
      "error": "Error message describing what went wrong"
    }
  }
]

Binary data is not produced by this node.

Dependencies

  • Google Cloud Platform: Requires access to a Google BigQuery project.
  • Authentication: Either OAuth2 credentials or a Service Account key must be configured in n8n.
  • n8n Credentials: You must set up either "Google BigQuery OAuth2 API" or "Google API" credentials in your n8n instance.

Troubleshooting

Common issues:

  • Authentication errors: Occur if credentials are missing, invalid, or lack required permissions. Ensure the correct authentication method is selected and credentials are properly configured.
  • Permission denied: The service account or OAuth2 user may not have sufficient permissions on the specified BigQuery project, dataset, or table.
  • Invalid project/dataset/table IDs: Typos or incorrect values will cause API errors.
  • Malformed queries: Syntax errors in SQL queries will result in error messages from BigQuery.

Common error messages:

  • "Request had insufficient authentication scopes": Update your credentials to include the necessary BigQuery scopes.
  • "Not found: Dataset <project>:<dataset>": Check that the dataset exists and the ID is correct.
  • "Access Denied: Table <project>:<dataset>.<table>": Verify permissions for the table.
  • "Syntax error: Unexpected keyword": Review your SQL query for mistakes.

How to resolve:

  • Double-check credential setup in n8n.
  • Confirm that the Google Cloud project, dataset, and table exist and are spelled correctly.
  • Ensure the authenticated user/service account has the right IAM roles (e.g., BigQuery Data Editor).
  • Test your SQL queries in the BigQuery console before using them in the node.

Links and References

Discussion