| 12345678 |
- Type | Details | Config options
- ------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------
- source | Creates a [source](/sql/create-source). | cluster, indexes
- view | Creates a [view](/sql/create-view). | indexes
- materialized_view | Creates a [materialized view](/sql/create-materialized-view). The `materializedview` legacy materialization name is supported for backwards compatibility. | cluster, indexes
- table | Creates a [materialized view](/sql/create-materialized-view) (actual table support pending [discussion#29633](https://github.com/MaterializeInc/materialize/discussions/29633)). | cluster, indexes
- sink | Creates a [sink](/sql/create-sink). | cluster
- ephemeral | Executes queries using CTEs.
|
