Working Tables

Reusable local query outputs you can build on over time.

What a working table is

Working tables are reusable local query outputs. When a query result is worth keeping — a join, a filtered subset, a comparison — you can save it as a working table instead of re-running the same exploration every time.

They are created from a saved Data Map.
They live locally on your machine.
They can be refreshed to pull in current data from the source.

Why save instead of re-query

A working table captures the shape of the query, not just one snapshot. Refreshing it keeps your analysis reproducible: same query, current data.

In Full

Full can publish working tables to a local SQL endpoint, so other SQL-capable tools on your machine can query the saved result. See Free vs Full.

Free limits

Free includes one working table. This is enough to try the full save → refresh cycle before deciding on Full.