Google BigQuery Connector

An Orchesty connector for Google BigQuery, a fully managed, serverless data warehouse that enables scalable analysis over petabytes of data.

Application Type

OAuth 2.0

This connector uses Google OAuth 2.0 with the auth/bigquery scope. After entering your credentials in Orchesty, you will be redirected to Google to authorize access.

| Field | Description | |---|---| | client_id | OAuth Client ID from the Google Cloud Console | | client_secret | OAuth Client Secret from the Google Cloud Console |

Components

| Class | Type | Description | |---|---|---| | BigQueryListAllDatasets | Connector | Lists all datasets for a GCP project via GET /bigquery/v2/projects/{projectId}/datasets |

Setup

Credentials

1. Go to the Google Cloud Console and open your project.
2. Navigate to APIs & Services → Credentials.
3. Create an OAuth 2.0 Client ID (type: Web application).
4. Add the Orchesty OAuth callback URL to Authorized redirect URIs.
5. Copy the Client ID and Client Secret.
6. Enable the BigQuery API under APIs & Services → Library.
7. In Orchesty, open the Google BigQuery application settings, enter the credentials, and complete the OAuth authorization flow.

API Documentation

Google BigQuery REST API: https://cloud.google.com/bigquery/docs/reference/rest

Installation & Usage

Install the package:

npm install @orchesty/connector-google-big-query @orchesty/nodejs-sdk
# or
pnpm add @orchesty/connector-google-big-query @orchesty/nodejs-sdk

Register the application and nodes in your Orchesty DI container:

import { container } from '@orchesty/nodejs-sdk';
import { OAuth2Provider } from '@orchesty/nodejs-sdk/dist/lib/Authorization/Provider/OAuth2/OAuth2Provider';
import BigQueryApplication from '@orchesty/connector-google-big-query/dist/BigQueryApplication';
import BigQueryListAllDatasets from '@orchesty/connector-google-big-query/dist/Connector/BigQueryListAllDatasets';

const app = new BigQueryApplication(container.get(OAuth2Provider));
container.setApplication(app);
container.setNode(new BigQueryListAllDatasets(), app);

License

This connector is released under the Apache License 2.0. See the LICENSE file for the full license text.

Contributing

Contributions are welcome! This connector is part of the open-source Orchesty Node.js Connectors monorepo.

For guidelines on how to create or update connectors — including project setup, coding conventions, and how to write tests — please refer to the Contributing to Connectors guide.

All contributions should include:

• Source code in src/ following the existing connector structure
• Tests in src/**/__tests__/ with input.json, mock.json, and output.json fixtures
• An updated CHANGELOG.md entry