Skip to Content

Google BigQuery Connector(With Queue Job)

by
Odoo

$ 199.71

v 16.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Community Apps Dependencies
Lines of code 4571
Technical Name google_bigquery_connector_with_queue_job
LicenseAGPL-3
Websitehttps://projects21.ai/
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Community Apps Dependencies
Lines of code 4571
Technical Name google_bigquery_connector_with_queue_job
LicenseAGPL-3
Websitehttps://projects21.ai/
Module Icon Google BigQuery Connector for Odoo

Odoo to BigQuery Sync, Made Simple

Connect your Google BigQuery project from Odoo, create datasets and tables from selected fields, and synchronize data manually or through scheduled background jobs using Queue Job and Cron Job Runner.

Key Features Screenshots Dependencies
Odoo Ready Select Fields to Sync Queue-Based Sync
Odoo to BigQuery Connector Overview
Overview: Odoo to Connector to Google BigQuery

Why this module?

  • Sync trusted Odoo business data into Google BigQuery
  • Create datasets and tables directly from Odoo
  • Select only the fields you want to publish
  • Run manual or background queue-based synchronization

What is included

  • Project connection setup
  • Dataset sync and creation
  • Table generation
  • Field mapping
  • Manual sync
  • Queue-based automation

Key Features

Clean setup, selective schema creation, and reliable synchronization into BigQuery with optional background processing.

Connect BigQuery Project

  • Upload service account JSON
  • Test and validate connection
  • Auto-detect project details
  • Fetch available datasets

Dataset Management

  • Sync existing dataset metadata
  • Create datasets if missing
  • Browse related tables
  • Manage datasets from Odoo

Table Creation from Selected Fields

  • Select Odoo model for export
  • Choose only required fields
  • Auto schema mapping
  • Column metadata management

Manual Sync

  • Run sync anytime
  • Batch processing with offset and limit
  • Sync-to-date tracking
  • Optional clear table data before sync

Queue-Based Sync

  • Run sync in background jobs
  • Track queue lines and batches
  • Job status visibility
  • Suitable for larger datasets

Schedule Automation

  • Use Odoo Cron for automated runs
  • Works with Queue Job Cron Runner
  • Hands-free synchronization
  • Reliable recurring data updates

How It Works

A simple workflow to move trusted Odoo data into BigQuery.

Step 1
Connect Project
Upload service account key and validate access.
Step 2
Sync or Create Dataset
Sync dataset metadata or create a new dataset.
Step 3
Create Table
Choose model and fields to generate schema.
Step 4
Sync Data
Run manually or use background queue jobs.

Screenshots

Full process coverage with all module screenshots, arranged in a clean marketplace-friendly layout.

1. BigQuery Projects List

View and manage all BigQuery project connections from Odoo.

BigQuery Projects list

2. Project Connection Form

Upload the service account JSON and configure the connector.

Project connection form

3. Dataset Screen

Create or synchronize datasets and manage their configuration.

Dataset screen

4. Table Mapping

Choose the Odoo model and selected fields to build the schema.

Table mapping fields

5. Field Selection Details

Review field tags, structure, and selected schema columns.

Field selection details

6. Table Structure / Configuration

Manage created table definitions and synchronization setup.

Table structure configuration

7. Table List / Linked Records

Browse synchronized tables and review linked dataset objects.

Table list linked records

8. Sync Data

Run manual sync or enable queue-based background processing.

Sync data and queue mode

9. Queue Job Monitoring

Track execution flow, timing, progress, and processing status.

Queue job monitoring

10. Final Process / Job Result Screen

Complete the process with final sync traceability and operational visibility.

Final process job result screen

Dependencies and Installation

Install the module, configure the service account, and start synchronizing data.

Python Requirements

Add a requirements.txt file in the module root:

google-cloud-bigquery google-cloud-storage

Odoo and OCA Dependencies

  • queue_job
  • queue_job_cron_jobrunner

Enable Queue mode on a table to process synchronization using background jobs.

Technical Information

Compatible Versions
Odoo 16.0, 15.0, 14.0, 13.0
Google Services
Google BigQuery, Google Cloud Storage
Background Processing
queue_job, queue_job_cron_jobrunner
Main Use Case
Selective Odoo data sync into BigQuery for analytics and reporting

Support

Need help with setup, configuration, or troubleshooting? Contact our team.

Email Support: projects@projects21.ai
@ 2026 Google BigQuery Connector — Odoo Custom Module

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.