# Replace a table with the result

Publish / database

A variant of [Write to a database](https://meridian.online/operations/write-to-a-database).

Create the table from the result, or empty and refill it, so it holds only the new rows.

Page: <https://meridian.online/operations/write-to-a-database/replace-a-table-with-the-result>

## Status

Not built yet.

arcform does not do this yet. [Its place on the roadmap](https://meridian.online/roadmap#write-to-a-database)

## What other tools call it

Meridian's classification; an independent blind rating agreed on 95.7% of 324 rows (variant, version 3).

- Alteryx Designer: [`Calgary Loader`](https://help.alteryx.com/current/en/designer/tools/calgary/calgary-loader-tool.html) (read 2026-09-27)
- Alteryx Designer: [`Write Data In-DB`](https://help.alteryx.com/current/en/designer/tools/in-database/write-data-in-db-tool.html) (read 2026-09-27)
- Bruin: [`create+replace`](https://getbruin.com/docs/bruin/assets/materialization.html) (read 2026-09-27)
- Bruin: [`table`](https://getbruin.com/docs/bruin/assets/materialization.html) (read 2026-09-27)
- Bruin: [`truncate+insert`](https://getbruin.com/docs/bruin/assets/materialization.html) (read 2026-09-27)
- Apache DataFusion: [`CREATE TABLE`](https://datafusion.apache.org/user-guide/sql/ddl.html) (read 2026-09-27)
- Apache DataFusion: [`Catalogs: Tables (CREATE / DROP TABLE, CREATE TABLE AS SELECT)`](https://datafusion.apache.org/user-guide/features.html) (read 2026-09-27)
- Apache DataFusion: [`SELECT INTO`](https://datafusion.apache.org/user-guide/sql/select.html) (read 2026-09-27)
- dbt-utils: [`table`](https://docs.getdbt.com/docs/build/materializations) (read 2026-09-27)
- KNIME Analytics Platform: [`DB Writer (DB Data)`](https://api.hub.knime.com/nodes/*Ts6MTyaKUWegubym?details=full) (read 2026-09-27)
- RapidMiner Studio: [`Store (In Database)`](https://docs.rapidminer.com/latest/studio/operators/extensions/In-Database%20Processing/indb_data_access/indb_store.html) (read 2026-09-27)
- SQLMesh: [`FULL`](https://github.com/SQLMesh/sqlmesh/blob/23b237cea7218cc8f338b89c14f0957394a0003b/docs/concepts/models/model_kinds.md) (read 2026-09-27)
- SQLMesh: [`MANAGED`](https://github.com/SQLMesh/sqlmesh/blob/23b237cea7218cc8f338b89c14f0957394a0003b/docs/concepts/models/model_kinds.md) (read 2026-09-27)