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.