Hi,
I’d like to start using native data tables. We use a self-hosted, protected production environment.
How do I move a data table to production? I can’t seem to find it when pushing to git.
Do I need to manually recreate it and then fudge the ID to match the test server?
Hi @cacl-dis
The Data tables | n8n Docs feature is available starting from n8n version 1.113.0
The latest version right now is 1.113.3, so you’ll need to update your n8n instance to start using data tables..
I am on 1.113.3 and can use data tables just fine. However as my question states I don’t understand how I’m supposed to move a flow that uses a data table onto a protected production environment.
@cacl-dis I was wondering if you found a solution for this? I am facing the same problem and considering using a migration workflow that runs in any environment which creates data tables and also fills the data. Similar to how database migration would work.
@cacl-dis having the same question
Pretty sure the way they are designed you can’t as they exist within the instance itself.
We use datatables extensively now for automations - particularly for things like auditing, static stores and sessions.
The way I’ve found to go from testing to production is to have a small automation that downloads the datatable data sends it to webhook on the other instance and uploads to the new datatables.
It still means you have to create the datatable schemas on the new instance, but it’s a way of getting your data there.
I am hoping n8n improve datatable exports and also add in new column types because it adds a whole new dimension to automation right now.
@maven Unfortunately no, our conclusion is still that datatables are not production ready and we are completely avoiding them in favor of external databases/redis.