🚀 Flexigo Odoo to BigQuery Free ELT Starter
Export Odoo data to Google BigQuery using free load jobs—no streaming charges, no data surprises.
Why This Module?
BigQuery is powerful for analytics and reporting, but streaming inserts cost money per row. This module uses BigQuery's free load-job ingestion path, keeping your data warehouse costs predictable and low.
Key Features
- Model & Field Selection: Choose exactly which Odoo data to export. Auto-excludes passwords and secrets.
- Multi-Company Isolation: Each company's exports are separate. Record rules enforce access control.
- Cron-Driven Syncs: Automated background syncs every 15 minutes. Respects per-config intervals.
- Error Taxonomy: Distinguishes auth failures, quota limits, schema mismatches. Cron retries appropriately.
- Chatter Integration: Failed syncs notify configurators. Config changes are tracked in the audit trail.
- Batch Processing: Configurable batch size (100–50,000) for large tables without memory bloat.
Quick Start
- Install
google-cloud-bigquery:pip install google-cloud-bigquery - Install this module in Odoo
- Go to Settings → BigQuery Export → Configurations
- Create a configuration with your GCP project ID and authentication credentials
- Select the Odoo models you want to export
- Click Test Connection to verify your credentials
- Click Sync Now to start the export
- Monitor progress in Sync Logs
What Gets Exported?
You choose. Select models and fields from the config form:
Security & Compliance
Pricing & Transparency
What's Free (included in the module):
What You Pay (Google Cloud):
The module's design guarantees free ingestion. Typical cost: 1–2 cents per million rows ingested (just storage and metadata).
Requirements
google-cloud-bigquery installedroles/bigquery.jobUser (project) and roles/bigquery.dataEditor (dataset)Support
License: LGPL-3 (open source)
Author: FlexigoTech
Website: https://flexigotech.com
For detailed documentation, configuration guides, and troubleshooting, visit our support portal.
© 2024–2026 FlexigoTech. All rights reserved.
Flexigo Odoo to BigQuery Free ELT Starter
Export Odoo data to Google BigQuery using free load jobs. No streaming charges, no data surprises.
The Challenge
BigQuery is powerful for analytics, but streaming inserts charge per row. Data warehouse costs spiral when you export Odoo records continuously. You need predictable, transparent pricing.
Our Solution
This module uses BigQuery's free load-job ingestion path. Export terabytes of Odoo data with zero per-row charges. Pay only for storage and queries—exactly what you use.
Core Capabilities
Free Load Ingestion
Load jobs (default path) incur zero per-row charges. You pay only for storage and queries.
Flexible Sync Modes
Full refresh or incremental (watermark-based) exports. Choose per-model. Run on a schedule or on-demand.
Secure Credentials
Service account files, pasted JSON, or Application Default Credentials. All encrypted at rest.
Data Residency
Specify EU, US, or any BigQuery region. Meet compliance requirements for sensitive jurisdictions.
Smart Schema Evolution
Automatically adds new columns as Odoo schema evolves. No manual DDL needed.
Detailed Audit Logs
Every sync creates audit trails. Know exactly what moved, when, and if it failed.
What Gets Exported
| Feature | Description | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Model Selection | Choose exactly which Odoo data to export. Auto-excludes passwords and secrets. | Full Refresh Mode | Exports entire models into new BigQuery tables (truncate-load). Ideal for master data. | Incremental Mode | Exports only new or modified records since last sync (append-load). Efficient for large tables. | Field Filtering | Hide sensitive fields. Auto-excluded: passwords, secrets, tokens, API keys. | Type Mapping | Odoo fields automatically mapped to BigQuery types (STRING, INT64, BOOL, JSON, etc.) | Multi-Company Isolation | Each company's exports are separate. Record rules enforce access control. | Batch Processing | Configurable batch size (100‑50,000) for large tables without memory bloat. |
Screenshots
Who Should Use This?
Data Analytics Teams
Export Odoo transaction data to BigQuery for real-time dashboarding, BI, and predictive analytics without paying streaming charges.
Growing Businesses
Control data warehouse costs as you scale. Free load ingestion means costs stay proportional to storage and compute, not row volume.
Compliance & Privacy Teams
Selective field export, data residency controls, and field-level audit trails enable GDPR and regional data governance.
Multi-Tenant Platforms
Multi-company isolation and record rules ensure tenant data never leaks. Each tenant's export is separate and secure.
Compatibility & Requirements
Odoo Version: 19.0
Python: 3.7+ with google-cloud-bigquery installed
Google Cloud: Project with BigQuery API enabled
Service Account: Needs roles/bigquery.jobUser and roles/bigquery.dataEditor
Supported Auth: Service account JSON, ADC (Application Default Credentials), or pasted key
License: LGPL-3 (open source, free to use)
Transparent Pricing Model
What's Free
- Ingestion via load jobs (zero per-row charges)
- Watermark queries for incremental syncs (minimal cost)
- Module download and updates (LGPL-3)
- BigQuery table storage (typical: 1‑2 cents per million rows ingested)
- Queries you run on exported data
- Optional streaming (if enabled, not recommended)
What You Pay (Google Cloud)
Frequently Asked Questions
Why free load jobs and not streaming?
Streaming inserts charge per row. Load jobs cost zero per ingestion. For most Odoo syncs, load jobs are faster and cheaper. Streaming is only needed for sub-second real-time, which Odoo doesn't require.
As often as you want. Each sync is scheduled via cron, configurable per export. Typical: every 15 minutes. No per-run costs—only storage and eventual queries.
Yes. Watermark-based incremental mode tracks the last sync timestamp and exports only new/modified records. Ideal for large tables. Reduces query cost and bandwidth.
Credentials are encrypted at rest in Odoo. Service account keys use Google's recommended IAM roles. Record rules enforce multi-company isolation. Sensitive fields can be excluded from export.
Yes. Configure data residency to EU, US, or any BigQuery region. Field-level audit logging tracks what was exported and when. Selective field export enables minimal data processing.
Ready to Export Your Odoo Data?
Start with the free LGPL-3 module. Install, configure your BigQuery project, and begin syncing immediately. No credit card required.
For support and documentation, visit flexigotech.com
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 952 |
| Technical Name |
flexigo_odoo_to_bigquery_free_elt_starter |
| License | LGPL-3 |
| Website | https://flexigotech.com |
Please log in to comment on this module