Skip to main content

BigQuery node

The BigQuery node lets you securely run SQL queries on your Google BigQuery datasets — perfect for large-scale data analysis with the speed and power of Google's cloud infrastructure.

Whether you’re working with millions of rows or running real-time dashboards, the BigQuery node gives you a simple way to connect and stream insights directly into your flows.

What can it do?​

  • Connect to your Google Cloud project using service credentials
  • Run complex SQL queries on BigQuery tables
  • Fetch results and turn them into usable datasets
  • Use in dashboards, slideshows, or downstream nodes

How to use it​

  1. Drag the BigQuery node onto your flow canvas.
  2. Fill in the required fields:
    • query: The SQL query you want to run.
    • projectId: Your Google Cloud project ID.
    • keyFilename: Path to your service account key file (.json).
    • clientId: Your OAuth2 client ID for secure access.
  3. Run the query and preview results in the output pane.
  4. Use the dataset like any other node output.

🔒 All credentials are stored securely and only within your user scope.

Example query​

SELECT country, AVG(population) as avg_population
FROM `my_dataset.world_data`
GROUP BY country
ORDER BY avg_population DESC
LIMIT 10

Example use cases​

  • Analyze billions of rows of retail or finance data
  • Power dashboards from centralized BigQuery tables
  • Join external BigQuery datasets with local or file-based data
  • Create live reporting flows using cloud-scale infrastructure

Tips​

  • Your service account must have BigQuery Data Viewer and Job User roles
  • Make sure your keyFilename points to a valid .json file
  • Queries must be valid standard SQL — BigQuery-specific functions are supported
  • If you're using OAuth, your clientId must be authorized in the cloud project

Security​

  • Your credentials are encrypted and never shared outside your user session
  • The .json key file is used locally and is not uploaded
  • Only the query results are stored in your flow output

BigQuery brings the power of Google Cloud to Datastripes — with no setup, no code, just insights.