I am using a Baserow hosted instance and am wondering if it is possible to download snapshots and then upload them to restore a database?
With the subscription I have I can only save two snapshots between the different databases I have. I would like to create a snapshot and download it locally.
Is there a way to save and restore the columns in a table without the data? That way I could create a table and then upload a CSV containing the data.
Hey @Troy! Currently, when creating a snapshot, you can only make complete copies of a database. And yes, snapshots allow you to restore a database to a specific point in time. You can have a maximum of 2 snapshots per workspace in all plans.
Is there a way to download snapshots locally and upload snapshots?
2 snapshots per workspace is quite limiting when there are more than 2 databases per workspace.
Hey @Troy, currently, it’s not possible to download screenshots. But I will discuss this with the team, along with the possibility of increasing the number of snapshots per workspace. I’ll keep you posted! 
If I could download/upload snapshots, two per workspace would be fine.
Hey @Troy, I’ve checked the request for downloading snapshots with the team. It will be possible once we implement this feature: Add context menu button and associated modal to export an application to downloadable ZIP (#1896) · Issues · Baserow / baserow · GitLab (it’s pretty high on the list). 
This is awesome! Downloading a snapshot could be a very handy way to migrate back and forth from self-hosted to SaaS, wouldn’t it? That would relax some customers with the SaaS offer, who fear that a simple “export to CSV, JSON, XML” will result in a migration nightmare. Importing a snapshot could fix this.
Cheers,
Stephan
For me, it is pragmatic.
With our team, I have quite a few non-technical people that enter and update data. It works really well for this use case as they understand how a spreadsheet works.
I review the data once a week. Before I review, I take a snapshot. I have to delete the oldest one first to make room. After I review, I delete the new snapshot and replace it with a new one. That way I have a semblance of weekly backups.
I have other databases I cannot backup because they don’t have high enough priority. I do have scripts pulling the data via API. I can use that data to rebuild, but I have to manually link the tables.
Yes, I would be very keen on being able to move data from SAAS to self-hosted and back. I have been tempted to have a private instance running so I can retrieve data if needed.
I really do like baserow. It appears to be a good mix between a full RDBMS and a spreadsheet (at least from the view of a non-tech user).
Just discovered this cool tool from a community member just a few minutes ago. However, it seems to not work properly at the moment, but it shows potential.
https://app.appsmith.com/app/import-export-baserow/home-6533ac8d517d1f5679b748e8
Hey @Troy @star26bsd 
The workspace import/export feature is coming in Baserow 1.29. For more details, see: Allow importing workspace applications (#2951) · Issues · Baserow / baserow · GitLab and Allow exporting workspace applications (#2930) · Issues · Baserow / baserow · GitLab. This will make it easier to transfer data between hosted and self-hosted versions of Baserow.