Google BigQuery Connector

A serverless, highly scalable, and cost-effective cloud data warehouse designed to help you make informed decisions quickly, so you can transform your business with ease.

Build with this Connector Talk to an integration expert

Low-code orchestration

Connect, compose and ship AI features faster.

Multi-tenant deployment

Isolate customer credentials and configurations at scale.

Governed access

Apply policies, field controls and audit trails across usage.

Embedded experience

Deliver workflows natively inside your product.

CONNECTOR OVERVIEW

Create automations with our Google BigQuery connector

Cyclr enables SaaS platforms to integrate their application with hundreds of other platforms. Use Cyclr’s low code integration builder to integrate your application with Google BigQuery, so you can provide in-app Google BigQuery integrations for your end users.

PRODUCT USE CASES

Top Use Cases for Google BigQuery Integrations

Quickly create integrations between your SaaS application and Google BigQuery with Cyclr’s low code integration builder. Publish your Google BigQuery integration into your application using Cyclr’s white label embedded integration marketplace.

Developer Tools

Combine external data sources and tools with your application's development environment to enhance your data
Add additional data and tools to your application using low code tools

Databases

Update data tool from new or updated rows in database
Update dashboard from new rows in data tool

ORCHESTRATION

How Google BigQuery works with Cyclr

Cyclr sits between your SaaS product and Google BigQuery to handle authentication, govern access and orchestrate every API call per customer, at scale.

1
Your SaaS product
Your app requests an action for a specific customer.
2
Cyclr orchestration
Cyclr authenticates, applies policies and routes the request.
3
Google BigQuery
Google BigQuery processes the request and returns a response to your app.

Customer-specific authentication · Governed data movement · Centralized visibility and audit

CONNECTOR COVERAGE

Available connector capabilities

Explore Google BigQuery methods you can orchestrate through Cyclr.

Tables13

List Table Data Incrementally (Per Page)

Action

List all table data incrementally with a fixed number of pages per transaction.

Insert Table Data (CSV File)

Action

Insert CSV file data into a table.

Get Table Structure

Action

Get a table's structure.

Create Table

Action

Create a new, empty table in the dataset.

List New Table Data

Action

List all table data created since the last successful cycle run.

List Partial Table Data

Action

List table data by a start index and number of records.

Update Table

Action

Update some field values on an existing table.

List New Table Data Incrementally

Action

List all table data created since the last successful cycle run incrementally.

List Table Data

Action

List all table data.

Insert Table Data

Action

Insert data into a table.

List Table Data Incrementally

Action

List all table data incrementally.

Overwrite Table

Action

Replace all fields on a given table with the included values.

List Created/Updated Records

Action

List all records created/updated since the last successful run.

Utilities13

Copy Table

Action

Create a job to copy an existing table.

Get Query Results

Action

Get the results of a query job.

Update Dataset

Action

Update the dataset.

Create Dataset

Action

Create a dataset.

Get Project Service Account

Action

Get the service account of a project.

Create Partial Query (Experimental)

Action

Execute a synchronous BigQuery SQL query with a start index and number of records.

List Tables

Action

List all tables.

Create Query

Action

Execute a synchronous BigQuery SQL query

Delete Dataset

Action

Delete a dataset.

Get Formatted Query Results

Action

Get the formatted results of a query job.

List Datasets

Action

List all datasets.

Get Dataset

Action

Get a dataset.

List Projects

Action

List all projects.

TECHNICAL DETAILS

Google BigQuery integration and API details

Review the sourced authentication and API behaviour used when configuring customer-facing Google BigQuery integrations in Cyclr.

API and authentication

API host: Not specified
Authentication: See Connector in Console
Credentials: Review the connector installation fields in Cyclr Console.
Method categories: See available methods

Pagination and rate limits

Pagination

Method-specific behavior should be confirmed before implementation.

Rate limits

Refer to the vendor API documentation for current limits.

IMPLEMENTATION

Authentication at a glance

Authentication requirements and any available connection options are shown when installing this connector in Cyclr Console.

Authentication method: See Connector in Console
Credential required: Review the connector installation fields in Cyclr Console.

KEEP EXPLORING

Related resources and connectors

Documentation