# Publish as a view

Publish / database

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

Save the query as a view or materialised view in the database instead of writing its rows.

Page: <https://meridian.online/operations/write-to-a-database/publish-as-a-view>

## 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).

- Bruin: [`view`](https://getbruin.com/docs/bruin/assets/materialization.html) (read 2026-09-27)
- Apache DataFusion: [`CREATE VIEW`](https://datafusion.apache.org/user-guide/sql/ddl.html) (read 2026-09-27)
- Apache DataFusion: [`into_view`](https://docs.rs/datafusion/latest/datafusion/dataframe/struct.DataFrame.html) (read 2026-09-27)
- dbt-utils: [`materialized_view`](https://docs.getdbt.com/docs/build/materializations) (read 2026-09-27)
- dbt-utils: [`view`](https://docs.getdbt.com/docs/build/materializations) (read 2026-09-27)
- SQLMesh: [`VIEW`](https://github.com/SQLMesh/sqlmesh/blob/23b237cea7218cc8f338b89c14f0957394a0003b/docs/concepts/models/model_kinds.md) (read 2026-09-27)
- SQLMesh: [`VIEW (materialized)`](https://github.com/SQLMesh/sqlmesh/blob/23b237cea7218cc8f338b89c14f0957394a0003b/docs/concepts/models/model_kinds.md) (read 2026-09-27)