| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 804 |
| Technical Name |
odoo_snowflake |
| License | OPL-1 |
| Website | https://niyulabs.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 804 |
| Technical Name |
odoo_snowflake |
| License | OPL-1 |
| Website | https://niyulabs.com |
Snowflake Connector
Send your Odoo data to Snowflake and unlock faster, smarter reporting. Turn everyday business activity into dashboards, charts, and insights your team can actually use. Odoo runs operationsâSnowflake turns the data into decisions.
✨ Super Simple Example:
You export Sales Orders from Odoo → then you open Snowflake → and you can see the table → and build a chart like “Sales this month”.
What does this module do?
It connects Odoo to Snowflake so your data can live in both places for reporting.
🚀 Export Any Model
You can export many things, like:
- Sales Orders, Invoices, Customers
- Products, Inventory, and custom models
🔀 Export Only New Changes
It does not keep exporting the same old data again and again. New rows get exported, changed rows get updated. This is faster and saves Snowflake cost.
⏱ Auto Export (Schedule)
Choose a time like every 15 minutes. Odoo will export automatically. No manual clicks needed. Great for near real-time dashboards.
❄ Safe Update in Snowflake
It will not create duplicate rows. If row already exists → update. If row is new → insert. This keeps the table clean.
Why do people use Snowflake?
Because Snowflake is great for analytics. It helps companies answer questions like: “How much did we sell this month?” “Which product sells the most?” “Who are our top customers?”
How it works
You don’t need to write SQL. Just follow these steps.
1) Setup
Add Snowflake details in Settings
2) Create Export
Pick model and columns
3) Run / Auto Run
Click Run or enable Auto Export
4) Check Data
See your table in Snowflake
What happens when you click Export?
- Odoo reads data from your model
- It sends data to Snowflake
- Snowflake saves it as a table
- Next time, it sends only new/changed data
Good first export to test
Start with a small model first, like Customers or Products. After it works, export bigger tables.
Step 1: Snowflake Setup
Go to: Settings → Snowflake Connector Pro
Fill these fields:
- · Account: Your Snowflake Account ID
- · User / Password: Login credentials
- · Warehouse: e.g.,
COMPUTE_WH - · Database / Schema: Destination location
- · Role: (Optional)
📷 Settings Screenshot
How to find your Account ID:
In Snowflake, run this query in a worksheet:
SELECT CURRENT_ACCOUNT(), CURRENT_REGION(), CURRENT_ORGANIZATION_NAME();
Account field entry: Combine them as ACCOUNT.REGION (e.g., HN81816.ap-south-1)
📷 Finding Account query
📷 Username location
Simple meaning of Snowflake words:
✅ Success Tip: Ensure your Snowflake user can create tables. Ask your admin if you hit permission errors.
Create an Export
This is where you choose what to send to Snowflake.
What is an Export?
It is like a saved “export button”. You can create many exports, one for each model you want.
Simple meaning of fields:
- · Export Name: Snowflake table name (e.g.,
sale_order). - · Odoo Model: Which model to export.
- · Columns: Which fields you want.
- · Auto Export: Toggle automatic sync.
- · Interval: Run frequency in minutes.
📷 Export Form
What columns should you pick?
Pick only columns you really need. This makes export faster. For sales: customer, date, total. For inventory: product, quantity.
📷 Selecting Columns
Domain Filter (Optional)
A domain filter means: “export only some rows”. If you don’t add a filter, it exports everything.
Examples:
Only confirmed Sales Orders:
Company 1 and amount > 1000:
Tips for filters:
- Start without filter to verify connection.
- Use Odoo search list filters to test your logic.
- Filters help keep Snowflake small and low cost.
📋 Pre-Export Checklist:
Did you pick the model? Selected columns? Connection saved? If yes, click Run!
Auto Export & Sync
This helps Snowflake stay updated automatically without manual intervention.
What is “incremental” sync?
It means: export only what is new or changed. Old rows are not re-sent, saving credits.
Interval Minutes:
How often auto export runs. Try 15 minutes for normal use, or 30-60 for huge databases.
📷 Automation Toggle
📷 Run Export Action
💡 Manual Run: You can always click “Run Export” manually even if auto-export is OFF.
Check Data in Snowflake
After export, you will see a new table in your Snowflake Warehouse.
Where is the data?
Table name is your Export Name. It is created automatically in your Database and Schema on the first run.
SELECT COUNT(*) FROM ODOO_DB.PUBLIC.SALE_ORDER_LINE;
Simple Check via UI:
- Database Preview: Open Data → Databases, select your Table.
- Worksheets: Run SELECT queries to see row data.
📷 Table List
📷 Database Preview
📷 Run Worksheet Query
What happens inside?
The module sends data to a temporary table → updates the main table safely → deletes the temp table. Exporting again is safe; it only syncs changes.
Fix Problems
Most problems are wrong settings or missing permissions.
Checklist:
- Account ID correct? (ID.REGION)
- Warehouse/DB/Schema names match exactly?
- Credentials (User/Pass) verified?
- Permissions: User must be able to CREATE TABLE and MERGE data.
⚠ Important: If you changed Snowflake table types before, you may need to delete the table once and re-export.
FAQ
Will it delete my data?
No. It updates old rows and adds new rows safely.
Can it handle big data?
Yes. It sends data in batches and only sends changes.
Works with custom models?
Yes. Custom models are supported.
Do I need SQL?
No. You just choose model and columns from the Odoo UI.
Can I stop auto export?
Yes. Turn off the Auto Export toggle anytime.
Where are my tables?
In Snowflake: Database → Schema → Tables.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module