Take your data with you
Your warehouse is a standard PostgreSQL database, so you can leave with a full copy. What sanda offers today, and what it does not.
Everything you connect, upload or generate in sanda is yours. Your warehouse is a PostgreSQL database, and that is a commitment in sanda's terms, not an implementation detail: it is what makes an export a database anyone can open, and it is what means leaving sanda does not mean leaving your data behind.
This page says exactly what you can do to take data out, and where the limits are.
A full copy of the warehouse
The console has no button that exports a whole warehouse, and sanda does not hand out database credentials, so you cannot point a tool like pg_dump at it yourself. The route to a full copy is to ask sanda.
Email hello@sanda-os.com.au and ask for a PostgreSQL dump of your workspace. Say which workspace, and which warehouses if you have more than one.
- When you close a workspace, the dump is a commitment. The terms say that if you ask before the read-only period ends, sanda will hand you a PostgreSQL dump of the whole workspace. It is not a courtesy sanda can withdraw.
- While the workspace is open, you can ask in the same way. The commitment in the terms is written for a workspace you are closing.
A dump is a standard PostgreSQL file, so standard PostgreSQL tooling can restore it into a database you run yourself. Your semantic fluid's definitions are stored by sanda separately from the warehouse's tables, so say in your email if you want those too.
When you close or delete a workspace
An owner can close a workspace from Settings · Workspace, at the foot of the tab. Closing makes it read-only: every page still opens, every question can still be asked, and an export can still be taken. After the read-only period, sanda destroys the warehouse and its contents, and backups containing them are overwritten within a further 30 days. An owner can reopen the workspace at any point before then.
An owner can instead delete the workspace straight away. That skips the read-only period. The warehouse and its contents are destroyed at once and cannot be recovered or exported afterwards.
Getting parts of your data out yourself
These need no help from sanda. They export what you have modelled, not raw database files.
| To get | Use |
|---|---|
| Tables and metrics into Excel, Power BI or Power Query | The OData feed. Nothing is installed, and every refresh reads the warehouse live. |
| A report's numbers as a spreadsheet or a PDF | Reports: sheets can be downloaded as xlsx, and a report prints to PDF from your browser. |
| Your semantic fluid's definitions as a document | The Download and JSON links in the What the agent is told panel on the semantic fluid page, once you press Show. This is your model of the business, not your rows. See agent context. |
The SQL shell shows results on screen and has no download button, and it returns at most 500 rows a statement, so it is not an export tool.
Something unclear or out of date? Tell us, and we will fix the page.