Skip to main content

Module for Odoo 17 · 18 · 19 · 20

Export Odoo snapshots to Snowflake without pipelines: chosen models and fields, manual or scheduled

Dumps the Odoo models you need into Snowflake tables with field-level control, manual or cron runs, full or incremental mode, protected exclusions so sensitive fields never leave, and logs of every sync.

  • Odoo versions: Odoo 20.0Odoo 19.0Odoo 18.0Odoo 17.0
Flexigo Odoo to Snowflake Snapshot Exporter module cover for Odoo

What it does

  • Model and field selectionEach configuration lists the exact models and fields that get exported.
  • Manual or scheduledRun on demand or on a cron matched to your analytics pipeline, in full-refresh or incremental mode.
  • Protected exclusionsRules that stop credentials and sensitive fields from reaching Snowflake.
  • Sync logsMetrics and errors of every run inside Odoo.

Odoo 17, 18, 19 and 20

Works on Community and Enterprise.

Through FlexigoTech Cloud

Odoo sends to Snowflake through FlexigoTech Cloud, with an active subscription.

The problem

Your operations run in Odoo and your analytics live in Snowflake. Bridging the two by hand - CSV exports, one-off scripts, brittle ETL - burns hours, breaks quietly, and leaves the ERP and the warehouse telling two different stories.

The solution

This module runs the export from inside Odoo itself: you configure which models and fields go across, choose full-refresh or incremental, schedule it with cron, and review each run in the sync logs. Built for BI, finance and operations teams - and for integrators who assemble data pipelines.

Real features, no fluff

Export any Odoo model

Choose the models you want in your warehouse - partners, sales orders, invoices or anything else - and add them to the export configuration as model lines.

Flexible scheduling

Trigger exports manually on demand, or automate them with cron schedules at whatever cadence fits your analytics pipeline.

Full-refresh or incremental

Pick per configuration between rewriting the full snapshot or syncing only the changes, based on each table's volume and how it is used.

Field-level control

Decide exactly which fields go to Snowflake and which stay in Odoo, field by field, from each model's field lines.

Sensitive-data protection

Built-in rules keep credential-like fields (passwords, API keys) from ever leaving Odoo, and you can define your own exclusions per model on top.

Real-time sync logs

Every run is recorded: success, partial sync or failure, each with the detailed error message so you can diagnose without leaving Odoo.

How it works

STEP 1

Install and connect

Install the module like any other and enter your Snowflake credentials (user/password or key-pair authentication) under Settings → Technical → Snowflake Export.

STEP 2

Choose what to export

Create an export configuration, add your models and set the field lines: what goes to Snowflake and what stays behind.

STEP 3

Schedule the sync

Run the export on demand or hand it to the cron. Choose full-refresh or incremental per configuration.

STEP 4

Watch every run

Check the Sync Logs: successes, partial syncs and failures with their error. Fix the cause and run it again.

Requirements (the real ones)

  • An active Snowflake account with valid credentials: user/password or key-pair authentication. The module stores them and uses them to write to your tables.
  • Odoo 17.0, 18.0, 19.0 or 20.0, Community or Enterprise edition. No additional licenses.
  • FlexigoTech Cloud: an active subscription; no third-party connectors needed.

Frequently asked questions

Does the Odoo to Snowflake export work on Odoo Community?

Yes. It works on both editions and is fully compatible with Odoo 17, 18, 19 and 20 on Community and Enterprise; the export runs with an active FlexigoTech Cloud subscription.

Do I need a Snowflake account?

Yes. You need a Snowflake account with valid credentials (user/password or key-pair). The module stores those credentials securely and uses them to write the data into your Snowflake tables.

Can I stop sensitive fields from being exported?

Yes. The module ships protection rules that block credential-like fields (passwords, API keys) by default so they never reach Snowflake, and you can customise field exclusions per model.

What happens if a sync fails?

Every attempt is written to the Sync Logs with a detailed error message. You open the log, fix the cause and run the export again. Partial syncs are recorded too, so you can catch issues without losing the whole load.

Does it handle large tables?

Yes. For high-volume tables set incremental mode so each run syncs only the changes; full-refresh is ideal for small tables or the initial load. You choose the mode per export configuration and match the cron cadence to your data volume.

How do I install it?

Like any Odoo module: download it from the Odoo App Store, install it from Apps, and set your Snowflake credentials under Settings → Technical → Snowflake Export. You are exporting within minutes.

Ready to get your Odoo data into Snowflake?

Try it in the live demo or buy it on the Odoo App Store - source code included.

Try the live demo View on the Odoo App Store

Snowflake guides

3 practical guides on this module: use cases, glossaries and guides for sellers without an ERP.